Clever Geek Handbook

Sql Import Wizard imports 1022868890 as 1.02287e + 009

I am trying to import some data from Excel into SQL Server, I have a TEXT column with some numbers in it, some of the numbers are going very well and some are turning into scientific form.

Column in Excel is "text" type, Column in target sql table is varchar (255)

Here are some examples:

Excel [text] → SQL Server [varchar (255)]
0313852230 → 0313852230
1024869004 → 1024869004
1022868890 → 1.02287e + 009
1022868899 → 1.02287e + 009
1022868907 → 1022868907
1030869319 → 1030869319
1106869726
SomeTe 11069

Please, help!

SOLUTION: Formatting the column as [Number] with 10 leading zeros worked for me since all my numbers are 10 digit numbers

+1


source to share


4 answers


SOLUTION: Formatting the column as [Number] with 10 leading zeros worked for me since all my numbers are 10 digit numbers



0


source


Are you sure that both Excel columns are text and the SQL column is VARCHAR?



I know SQL imports to float columns are exponential (which is the correct float representation)

0


source


When importing into Access, I found the only column type that works for directly importing numbers of this type is Zip (Format-> Cells-> Special-> Zip Code). This can also happen with SQL Server.

0


source


One more tip, I prefer to use SQL Server 2000 Data Import and Export Tool or DTS Import / Export Wizard

This method is less stringent than the SQL Server 2005 import tools. Quite often I am able to get the data imported into my database.

0


source






More articles:


All Articles