Hi,
I am trying to import data from Excel to SQl2005,sp1 table.
Excel has col with cells are formatted as 'General' and with sample data:
1
1.01
1.02,
11A1
12D9
The import runs fine but it excludes data values 11A1,12D9 etc..
The destination col is varchar(10).
I also tried formatting excel cells as text but no success.
Any idea what needs to be done to import the alphanumeric data.
Thanks for your help.
Jp