Posted by Frank on 11/22/07 06:52

I have a CSV file that i need to import into a SQL table. The problem
is the values in the first column are not brackited in "". There are
over 700K rows. Is there an easy way to fix the data or have SQL
correctly import the the data?

The data looks like this

1, "xxx","zzz"
2, "aaa","bbb"
an so on...

Thanks

• Next in forum: Re: Launch storedquery for each record
• Prev in forum: sqlcmd and escape characters
• Thread view: importing a CSV file

[Reply to this message]