I am trying to import and Excel spreadsheet as a table into an Access database. I have done identical things in the past from the same file location without a hitch. However, now I am having a persistent problem. Specifically, I go through all the steps in the Wizard (Use Sheet 1, First Column contains headings, All columns are text, Use autonumber as primary key), but when I name the spreadsheet and click "Import", I get the following error message: "The search key was not found in any record."
What search key is this referring to? How was there something there in all my other spreadsheets but not in this one? I'm confused.
Thanks for any light anyone can shed on this.