Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    18

    Unanswered: Impoting Excel Sci Notation Issue

    I'm importing a huge table from Excel, and all goes pretty smoothly except a Cost Center column. It contains the ten digit alpha numeric cost center. For some reason it converts a small number of the entries to scientific notation during the import.
    Is there any way to prevent this?
    Should I be asking on the Excel forum?
    -Doug Picanzi

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    not sure how to get rid of excels problem, but I find that when importing excel files to sql it is generally less troublesome if you save the .xls file as a text file (.csv), then import the text file to sql.
    des

Posting Permissions

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