Wednesday, March 7, 2012

Copy comma separated text file into a Sql server table

Hi
I have a comma separated text file which I would like to import into a table. There are some columns which are enclosed in double quotes and others which are not. I've tried bcp - it didn't work.
Can anyone help ? An example would be helpful.
Thanks
YogeshUse the DTS import wizard.
Source: Text File, enter your text file location
text qualifier: Double Quote {"}

No comments:

Post a Comment