import problems | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

import problems

I am having problems getting some data into SQL Server using DTS. I have a result field which is a text field in excel which looks like this:
797
829
<770
<771
<766
692
815
860
I am importing into a varchar field, but all of my numbers come in as nulls. Any ideas? I tried saving as a text file but that did not seem to help. Thanks for your help. Archer
When you try from txt, can you see numbers in wizard using manually import?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
One workaround is to save the Excel sheet as a text file and then you use the DTS Wizard to import the file into SQL Server.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>