SQL Server Performance Forum – Threads Archive
Import problemI 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
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