>I'm trying to import a CSV file into SQL. I have the SQL code working, then I found out that the file has commas embedded in the data:
>
>
>3000 Server - N4000,A6914CR,"3000 Server - N4000 - 1-way, 500MHz",A3639-67021,Electronic Parts,Cable Kit
>
>
>Notice that the third data item is enclosed in quotes and has a comma in it, so when the SQL batch import code runs, it brings the data in wrong.
>
>The question is, how do I clean up this data. There is going to be many files, with 5000+ rows each.
How about using VFP to clean the files before the upload?
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright