IMPORT CSV FILE -TYPE CONVERSION FAILURE

  • Thread starter Thread starter Brent
  • Start date Start date
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
 
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]
 
Back
Top