Unanswered: Microsoft Jet database engine could not find object
Has anybody heard of or have a solution for this:
I used to be able to quickly create tables in Access by pasting a spreadsheet from Excel directly into the tables pane. Access would ask if the first row contained headings and then it would create a table with the name that appeared on the spreadsheet tab.
Now I get this message after asking about the first row:
"Microsoft Jet database engine could not find object...." followed by a string of characters which includes the tab name from Excel.
I've tried using a blank database and variations of Excel files but nothing works. Access will still import the file through the import wizard. I have tried repairing the installation but I don't really want to reinstall the software suite just for this one error.
Maybe its not a commonly used feature but my circumstances made it a useful trick which only recently stopped working.
To be clearer, I would select only the cells which basically formed the data and structure of a table in Excel, complete with headings, and then paste it into the Tables pane in Access. Access would oblige by creating a table from it, regardless of size. A nifty feature.
I'm fairly sure something's corrupted and I'll probably end up reinstalling MS Office and my other related aps. I was just hoping someone would know of an easier and faster solution.