Import problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import problem

I can think of kludgian ways to do this, but what is the best method to solve this problem/issue? I am trying to import an Excel spreadsheet into SQL Server. One column is a combination of numbers and character strings. When I import the ss, only one set(either the numbers or characters strings) gets imported depending on the data type for the column, but the other set is set to null. I am using the DTS through EM. Thanks for your help. Archer
Maybe I did not explain myself properly. I have an Excel table which looks like this MW-06
12345
34567
789933
7345987
9534
23985
23497
58943
234789
23497
MW-01
MW-02
MW-03 When I import into a table, either the numbers or character strings become null. When the column is a varchar(50), the numbers get imported as null strings, etc. Could someone PLEASE help me understand why and how to fix this issue. Thanks a lot. Archer
Do you have different cells from that same column defined as different data type?
The data type for the entire Excel column is "text". Archer
Same problem about a year ago and went crazy trying to figure out the cause. Hope this helps. http://www.sqldts.com/default.aspx?254 Raulie
Hewlett-Packard
]]>