Oct 26 2007, 02:15 PM
I am importing a small (50 Rows X 25 Columns) Excel spreadsheet into Access. All of the cells on the spreadsheet are formatted as "Text". Ninety-nine percent of the spreadsheet fields come into Access correctly. The remaining fields come in as the #NUM! error. The fields surrounding the error fields are correctly populated, with no blank fields or missing information. All the Access field properties are set as text, 255. The error occurrs sporadically across the spreadsheet. I tried changing the format from @ to & witihout any change to the import.
The exact same text successfully imported in one field, will give the #NUM! error in the next one.
What am I doing wrong?
Thank you in advance.
Oct 26 2007, 02:56 PM
Excel and Access don't always play nicely when you're importing into Access.
Since Access doesn't let you define an imported field's data type, it can be a challenge to get it imported. What I normally do is to use a tab-separated .txt file saved out of Excel and then set up an import spec in Access that sets the data types/sizes at that point. This gets past any data typing issues and allows the data to import without problems.
Oct 28 2007, 07:21 AM
Thank you for the help. It works fine now.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here