Post reply

DTS and Excel

  • April 16, 2002 at 10:14 am

    #357514

    When I use DTS to import data from Excel (5.0) if the column has characters at the top and numbers further down the numbers are converted to NULLs in the table. The reverse happens if numbers are at the top. How do I ensure it imports all the values from all rows?

    Mike

  • April 22, 2002 at 9:55 am

    #427590

    It could be the format of the columns in excel. Not sure how it does it but it might read the column datatype to be able to translate it. I had loads of problems with Excel so ended up saving it as a .CSV and then importing as a text file.

    Andy.

  • April 22, 2002 at 8:55 pm

    #427645

    One way you can get around this is by preceeding any numbers in the column with a single quote (') This tells excel to treat the number as text.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply