Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    91

    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.

  2. #2
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    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.

    Good luck,
    Hope this helped

  3. #3
    Join Date
    Nov 2005
    Posts
    91
    I actually tried both steps and still cannot change the sources data type.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •