What is a search key to import Excel to Access?

S

Sue

Trying to import an Excel spreadsheet into an Access 2007 table. Get the
error "The search key was not found in any record". I never encountered this
in earlier Access versions and can't find anything in Help about a search key.
 
K

Ken Snell [MVP]

That error message typically indicates a corruption of the ACCESS database.
Typical way to fix is to create a new database, and import all the objects
from the older database into the new database. In ACCESS 2007, this is done
by clicking on External Data tab on the ribbon, clicking on Access icon in
Import group, and follow the wizard's prompts.
 
K

Kaykayme

I had the same error but by removing the spaces at the beginning of the field
names in my spreadsheet I was able to import my file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Import Formatted text as new Slides in PowerPoint 0
Dumb question alert! What program to use? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Export BPMN Visio Chart to Excel 0
search key 0
Error importing from Excel message "The search key was not found" 1
Import Wizard Error Message "The search key was not found in any r 2
Error importing from Excel 1

Top