Post reply

Field value showing as 8.00002e+007

  • April 8, 2008 at 12:40 pm

    #69768

    I've imported an excel table into sql. However the field "CustomerNo" is made up of eight chars (i.e. 80000001, 80000002, 80000003.....80000045, etc). But when I view the table in SQL, it shows the values as 8e+007.

    What can be causing this?

    thx,

    john

  • April 8, 2008 at 1:32 pm

    #799984

    What type of field is CustomerNo is your sql table? How is the column formatted in the excel sheet? It sounds like you imported the field from a general format in excel to a varchar in sql. Format the column in excel to numeric fixed with no decimal places.

  • April 8, 2008 at 3:39 pm

    #800042

    Actually, I figured it out. I was saving the excel file as .xls and it should be saved as .csv.

    thx,

    John

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

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