Import Excel 2010 to access 2010 creates Scientific notation numbers
I had imported the data before and did not have this problem.
I have 2 excel files I am importing to Access to become tables.
In Excel, cell format for the column set to custom #################### (19 # symbols)
In Excel all the long numbers show as normal.
If I change format to text, the numbers change to scientific notation UNTIL I click on EVERY cell in the column displaying incorrectly, So I leave it at custom (####...) so they show correctly
I have even added a 2nd of of text at the top row( I copied the top row and pasted it under itself. )
In Access, when importing , the default classification is Text so I leave it there. I did try long integer, but it did not work for my data which is a mix of numbers and text.
after importing, all fields in access show as text
But it changes all the long numbers to scientific notation.