SQL Server Performance Forum – Threads Archive
import problemsI 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:
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?
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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.