Importing Excel file, text formatted number fields change to scientific notation

[ajones]

I have imported an excel file into access. After importing though, the text format changes the numbers to scientific notation, for example 723252238464 changes to 7.23252E+11. In excel the field was formatted to text, and is text as well for access. All of the fields with long numbers after importing have changed to scientific notation. How do I prevent that?

 

[Fornatian]

Make your columns wider?

 

[Pat Hartman]

The field is not defined as text in Access. If it were, Access would not convert the numbers to scientific notation. If you want the field to be imported as text, you will need to create a table with the correct data type definitions. Then import the spreadsheet to an existing table rather than creating a new one.