Data type problem

[foxygrandma]

When I import Excel sheets into Access the numbers are put into scientific notation format. For example:

I imported an Excel sheet with a "Delivery Number" column. For example: the number should come in as 40846268. It comes in as 4.08463e+007. Is there an easy way to fix this?

[puppydogbuddy]

The probable cause is that the field definition you created for the field in the Access table is incompatible with the way the field is formatted in Excel. For example you may have defined the field's numeric data type as long integer in the Access Table, but it is formatted as a general number with 4 decimal places from excel.......so again, carefully compare the Access field definition in the Table with the way the cells are formatted in excel, and correct, accordingly.