How to Remove Double Quotation Marks while Importing a CSV File


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.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s