Bulk Insert of CSV still has double quotes it in SQL server database 2019

Question

Please help. This is the Bulk insert code to insert Employee data into SQL server 2019.The data is being inserted. but still with quotes. How to insert data without quotes? Please let me know what wrong AM' I doing?

BULK INSERT dbo.tblActiveDirData FROM 'E:\EmployeeData\ATadUserlistDB.csv' WITH ( DATAFILETYPE = 'char', FIRSTROW = 2, FIELDTERMINATOR= ',', ROWTERMINATOR = '\n' )

You didn't specify that fields are quoted

Panagiotis Kanavos
– Panagiotis Kanavos

2022-04-15 14:20:18 +00:00
Commented Apr 15, 2022 at 14:20 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Apr 15, 2022 at 14:20

RF1991 · Accepted Answer · 2022-04-15 20:56:04Z

1

This worked:

BULK INSERT Test_CSV FROM 'C:\MyCSV.csv' WITH ( FORMAT='CSV');

No other other code with field terminator, datafiletype was needed

edited Apr 15, 2022 at 20:56

RF1991

2,2634 gold badges12 silver badges20 bronze badges

answered Apr 15, 2022 at 14:35

SaraDob

6911 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bulk Insert of CSV still has double quotes it in SQL server database 2019

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related