I checked the MS knowledge base, and all references to this error message in Access world pertain to 'special' characters in a memo field.
But I get this error when I try to run code that contains a doCmd Transfer spreadsheet command. It's trying to import four worksheets into four access tables. The four spreadsheets are all formatted EXACTLY the same way.
Is there a way to "Trap," and see what line the code is 'barfing' on ?