search key not found in any record

T

Tom Stewart

I am trying to import a spreadsheet from Excel 2007 into Access 2007 and I
receive the search key not found in any record message. I have copied the
spreadsheet to a new workbook and even dropped some columns I don't need but
I still get the message and thus can't import the spreadsheet.
 
G

Gina Whipp

Tom,

Now down to the other reasons this would happen... Could be there is some
corruption in the Excel spreadsheet, could be the way Access is translating
your columns in Excel, could be there are
calculated fields in Excel that Access can't translate for what ever reason.
So going to need a little more information...

1. Any calculations in the spreadsheet?
2. What are the fields names?
3. Have you looked at the spreadsheet to confirm there are no errors on the
sheet?
4. Just on a whim here, do you column headings use any reserved words that
might confuse Access?

I just just tested this using an Excel worksheet and text and both work fine
so I am thinking the problem ight be the spreadsheet.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

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

Access 2007 Excel Import Error 1
The Search Key was not found in any record... 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Wizard Error Message "The search key was not found in any r 2
Search key not found in any record 3
Importing Excel Data - Error Message 3
Error importing from Excel message "The search key was not found" 1
What is a search key to import Excel to Access? 7

Top