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

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'
     
)
sqlsql-server


Solution 1:[1]

This worked:

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

No other other code with field terminator, datafiletype was needed

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 RF1991

Related Questions