Import excel spreadsheet into Sql Server schema - numbers become exponentials: Why? Fix?
Posted on 2007-04-09
I have an excel spreadsheet that I import into a table in a SQL server schema. Once I import it, all the data appears perfectly EXCEPT a column (record_num), which has 6-8 digit numbers. On the Excel sheet this column displays the numbers just fine, but once I import it into a SQL table, the data in that column looks like this : "2.12043e+006" (instead of 2120426)
Now I looked at the SQL table's design and the data type is set to "varchar: 100"
If I re-format the column in excel as general, text, or number - I still get exponentials instead of the ACTUAL 6 or 8 digit number.
What am I missing? There's over 400 rows of data.