Home Forums SQL Server 2008 SQL Server 2008 - General Importing a csv file into a database - inserts quotes automatically into every field RE: Importing a csv file into a database - inserts quotes automatically into every field
Ant-Green
SSC Guru
Points: 113445
More actions
January 10, 2013 at 3:44 am
#1575692
If it speach marks " (double quote), the text qualifer should just be a speach mark, you dont want to wrap it up into a string so '"' (single, double, single)
If that doesnt work are you able to share the file so I can take a look.