Unable to Import data in .csv file using 'SQL Server Import & Export Wizard'

[VijiKumara]

Hi,

I am trying to import the data in.CSV and create a table on the fly on MSSQL. It's failing for one of the columns, where it has a very long string. Please see the error attached. While importing, under Edit Mapping, I do not find any option to increase the number of characters varchar can hold.

Please advise.

Thanks in advance, for the help.

Kind,
Vijay

 

[simian336]

The error indicates that one or more of the columns you created are not long enough to store the data that would be imported into the field.

Make you Columns longer and that may fix the problem.

Simian