CODEWITHSUNDEEP
sqlsql-server-2008csv
opaera
opaera

Reputation: 11

Import CSV within SQL Server 2008 Management console

I'm trying to import a CSV file within the SQL Server Management console. The CSV is comma delimited.

I have some columns that has a comma within double quotes, it seems that SQL Server splits the value in 2 columns.

How can I solve this?

I hope you can understand what I mean.

Thanks in advance.

Upvotes: 1

Views: 725

Answers (1)

gbn
gbn

Reputation: 432561

You have customise the column separators for this column as starts ," and ends ",

You can do this in a dedicated SSIS package (which is what SSMS uses underneath). Similar to format files with bcp/BULK INSERT. I can't check right now sorry if the same option is offered in the SSMS wizard

Upvotes: 2

Related Questions