[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • Last Modified:

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.
0
lrbrister
Asked:
lrbrister
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
lrbristerAuthor Commented:
angelIII:
I'm not using a DTS package on this.  I'm using SQL Server 2005 Import Wizard
0
 
Guy Hengel [angelIII / a3]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
 
lrbristerAuthor Commented:
My apologies
Didn;t read through completly
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now