0

I have a set of quoted CSV files, which I need to import into SQL Server. Files look like this:

"ColA","ColB","ColC"
"12345","John Smith","-75.33"
"12356","Jane Doe","43.12"

BCP and BULK INSERT commands do not work because SQL Server cannot handle quoted fields.

How can I import files such as above?

  • 2
    Not true. Both BULK INSERT and BCP support format files. – spaghettidba Nov 3 '15 at 13:45
  • Yes, but suggested answer does not require format files. – Serge Nov 5 '15 at 1:09
1

OPENROWSET command and Microsoft Access Text Driver (*.txt, *.csv) driver come to the rescue:

SELECT *
FROM OPENROWSET('MSDASQL',
'DRIVER={Microsoft Access Text Driver (*.txt, *.csv)};
DefaultDir=D:\CSV file directory;
Format=CSVDelimited;
CharacterSet=ANSI;
',
'SELECT *
FROM [filename.csv]')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.