Post reply

DTS from Excel to sql server table not importing alphanumeric fields

  • May 31, 2006 at 7:35 am

    #366280

    hello all, i have an issue with doing a DTS in my sql server 2000. I am trying to import an excel worksheet into my sql server database using dts, one of my columns is alphanumeric i.e. CA32633 and some in the same column are only numbers i.e 36363, so when i made my table in sql server i made this column varchar.... now when i run my dts to try to export this table the ones with letters do not get transferred, only the ones with numbers... I also tried changing the datatype of this column as text, float, and nothing... can someone help?

     

     

    I would really apreciate it!

     

     

  • May 31, 2006 at 8:13 am

    #640938

    The Excel driver is a bit squirrelly in how it determines the datatype of the source. It looks at the first few rows and then tries to determine datatype based on what is in those. Have you tried saving your Excel file as a .csv file, and then importing that instead?

  • May 31, 2006 at 8:16 am

    #640940

    I found a link documenting the problem to give you the official response.

  • May 31, 2006 at 8:55 am

    #640953

    thank you sooooo  much, i did what your link said to saved it as txt file and it works like a charm. thank you!!!!

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

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