Import CSV within SQL Server 2008 Management console

Question

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.

gbn · Accepted Answer · 2010-10-22 19:26:40Z

2

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

answered Oct 22, 2010 at 19:26

gbn

435k84 gold badges602 silver badges690 bronze badges

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

Collectives™ on Stack Overflow

Import CSV within SQL Server 2008 Management console

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related