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.
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
0
 
Larry Bristersr. DeveloperAuthor Commented:
angelIII:
I'm not using a DTS package on this.  I'm using SQL Server 2005 Import Wizard
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I presume you only looked at the accepted answer, and not at the links I posted before that accepted answer there.

anyhow, another site, same question, same links:
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f9411517-500a-4d62-be63-b645a6244dea/
0
 
Larry Bristersr. DeveloperAuthor Commented:
My apologies
Didn;t read through completly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.