Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

VijiKumara

Programmer
Mar 13, 2018
17
US
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.
Error100_dkemsq.jpg


Thanks in advance, for the help.

Kind,
Vijay
 
 https://files.engineering.com/getfile.aspx?folder=d54d13db-2dc8-48d2-9e1e-866ee50ba769&file=Error100.JPG
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top