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.

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.

Thank you for the help. It works fine now.