IMPORT CSV FILE -TYPE CONVERSION FAILURE

B

Brent

I am importing a CSV file and I am getting a type conversion file one of my
fields (a upc file). I need that filed to be imported as a nvarchar... Is
there a way to set that field format on or before format?

I brought it into excel and imported it that way, and it came over float..
and when I converted in the table (design) to nvarchar- the data looked like
8.81E+10 and will not work for my SQl link....

Any ideas on getting the converion to match up?

Thanks
Brent
 
J

John W. Vinson

I am importing a CSV file and I am getting a type conversion file one of my
fields (a upc file). I need that filed to be imported as a nvarchar... Is
there a way to set that field format on or before format?

I brought it into excel and imported it that way, and it came over float..
and when I converted in the table (design) to nvarchar- the data looked like
8.81E+10 and will not work for my SQl link....

Any ideas on getting the converion to match up?
Click to expand...

You may want to use the Import Wizard - and select the Advanced tab.
That lets you specify which columns to import, the datatype of each,
etc.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
TYPE CONVERSION FAILURE - text to text field 3
Trying to create custom labels from an csv file + Need items numerically counted out 0
Convert PDF to Visio File or Editable PDF in Visio 0
Type Conversion Error While Importing (Time Field) 8
import problem: type conversion failure 0
Cannot import CSV file into ACCESS 1
Type Conversion Failure!!!! 8

Top