Search Key Not Found Error

  • Thread starter Thread starter Nikki
  • Start date Start date
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.
 
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
 
Back
Top