Larry Brister
asked on
Import Data
I have an excel file that I;ve saved every way I can..to cvs, text..etc...
Column1 has alpha alpha/num and numeric type data in it.
column1
A220
A221
0178
7124
A223
It will import the A221 etc...but not the numeric "looking" data. It inserts a null value.
I have it at nvarchar(50) right now.
Column1 has alpha alpha/num and numeric type data in it.
column1
A220
A221
0178
7124
A223
It will import the A221 etc...but not the numeric "looking" data. It inserts a null value.
I have it at nvarchar(50) right now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My apologies
Didn;t read through completly
Didn;t read through completly
ASKER
I'm not using a DTS package on this. I'm using SQL Server 2005 Import Wizard