Unanswered: DTS Help With Uploading An Excel Spreadsheet
Can somebody please tell me what I am doing wrong or need to do to resolve my issue. I having problems with one of the columns in an excel spreadsheet that I am trying to upload into the system. One of the columns contain values of both text and numbers such as 'ABC123', 'ABC124', '123456' etc. When I try uploading the sheet into SQL Server 2000 using DTS, the system removes all characters from the one column that I am having problems with. So entry 'ABC123' for example would be truncated to '123'. I tried formatting the column that I am having trouble with in excel to 'General' format as well as tried to transform the column to type varchar in SQL Server while using the DTS wizard but still had no luck. The problem is that SQL server thinks that the column is a float type column from the source and therefore truncates any characters.
Well it seems that you are answering your own question.
The problem is that SQL server thinks that the column is a float type column from the source and therefore truncates any characters.
You will just need to play around with DTS and the import functionality of SQL to solve your issue. When you import into a new table using the import wizard be sure to go into the "transform" section and there you should be able to change the column type.
If this still fails trying creating the table structure first, this might force the spreadsheet data into the new column type.