How to Remove Double Quotation Marks while Importing a CSV FilePosted: October 28, 2014
From SSMS (2014) >>Right click on your database name >>Import and Export Wizard >>click Next>> From the General screen, Choos Flat File Source as Data Source and Browse to the text file (double quotes CSV file)
and In Format section: Delimited ; Text qualifier– type ” (a double quote ) . The other values leaves as default >> click Next>> click Next>>
Choose a SQL Server Native client as a destination and choose a database and table to import the text file >>click Next>>click Next>> Finish.
The key part is to use a ” as Text qualifier for the import.