Error Message while Importing Data

J

Jen Scott

I'm getting the following error message when I try to upload a MS Excel 2007
file into Access 2007 --

The search key not found in any record.

What am I doing wrong? I upload files all of the time and have never had
this issue before. Thanks for your help!
 
G

Gina Whipp

Jen Scott,

Might be a field name issue... what are the field names on your Excel
Spreadsheet? Any spaces in them? Any special characters?

--
Gina Whipp
2010 Microsoft MVP (Access)

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

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

I'm getting the following error message when I try to upload a MS Excel 2007
file into Access 2007 --

The search key not found in any record.

What am I doing wrong? I upload files all of the time and have never had
this issue before. Thanks for your help!
 

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

Error importing from Excel 1
Importing Excel Data - Error Message 3
Import Wizard Error Message "The search key was not found in any r 2
Error message when importing external data 1
What is a search key to import Excel to Access? 7
Search Key Not Found Error 2
Pictures or No pictures??? 4
Issues Importing .xlsb Files into Access 2007 0

Top