[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


"Search Key was not found in any record" Excel or TXT import to MS Access2007

Posted on 2009-12-22
Medium Priority
Last Modified: 2013-11-29
I receive the error "Search Key was not found in any record" when I try to import records to create a new Access table. I am using Access 2007.  I have tried compacting and repairing the database.  I have tried cutting the data from the Excel file and pasting to a new spreadsheet.  I have created a .txt  file and tried to import also with no luck.

Is there anything in the file that could cause this problem?  Thanks.
Question by:thutchinson
  • 2
LVL 13

Expert Comment

ID: 26106627
I would try a couple of things here:

1) Try importing the file into a new (blank) database.
2) Create the table manually, and then try importing the data into the existing table.
3) Try one of the solutions mentioned here: http://www.utteraccess.com/forums/showflat.php?Board=83&Number=249362
LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 26106685
Check that you do not have leading spaces in any column headings in Excel.


Author Comment

ID: 26106716
Thanks, guys.  These are good suggestions.  I'll try them and let you know.

Author Closing Comment

ID: 31669082
How cool is that!  Removed some leading spaces in the header and presto.  THANKYOU so much!


Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question