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

Posted on 2009-12-22
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
    LVL 13

    Expert Comment

    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:
    LVL 77

    Accepted Solution

    Check that you do not have leading spaces in any column headings in Excel.


    Author Comment

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

    Author Closing Comment

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


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now