Hi All,
I am having a problem copying excel 2007 files into a table in access 2007. The ID field in excel was formatted to number because it was originally a text file that looks like the following: 1.983E+15
to the following 1979999357230200. When I export these file to access 2007, it appears like this again: 1.983E+15 How do I change it in access to appear as a number. I am using this field as the primary key.
Please help
Thanks