IMPORT CSV FILE -TYPE CONVERSION FAILURE

[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

 

[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?

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]