Search Key Not Found Error

N

Nikki

All:
Can you please help me? I am getting an error that says "The Search Key was
not Found" when importing a txt file into Access 2003. Do you have any idea
how I can fix this issue and get my data imported into Access? The file size
is too big to import into Excel.

Thank you so much for your help.
 
R

Rachel

Hi Nikki

I get this problem too, especially when dealing with large files. I try to
get around it by either linking it 1st, then copying it when it is in Access
& pasting it as a local table (structure & data), OR sometimes when i compact
& repair the dbase (make a copy if you need to 1st), I will then link & copy.

Hope this helps
Rachel
 

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

What is a search key to import Excel to Access? 7
Error importing from Excel message "The search key was not found" 1
Search key not found 2
Error importing from Excel 1
Search key not found 2
Search key was not found in any record 2
>> Search Key 5
Search Key Not Found? 4

Top