Access Import Text msg "search key was not found in any record"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Strategic Systems - 17 Aug 2005 19:53 GMT

Access 2003 Import Text Wizard returns the error message "The search key was
not found in any record." What search key is it looking for. I am trying to
imported a text file delimited by |.

Reply to this Message

tina - 18 Aug 2005 00:42 GMT

are you running the Import Wizard manually? at what point in the process
does the error pop up?

> Access 2003 Import Text Wizard returns the error message "The search key was
> not found in any record." What search key is it looking for. I am trying to
> imported a text file delimited by |.

Reply to this Message

Strategic Systems - 18 Aug 2005 12:27 GMT

I set up the import text, run it, and when it's done, that message pops up.

> are you running the Import Wizard manually? at what point in the process
> does the error pop up?
[quoted text clipped - 4 lines]
> to
> > imported a text file delimited by |.

Reply to this Message

Lynn Trapp - 18 Aug 2005 14:09 GMT

Which Jet Service Pack are you on? This problem was encountered sometimes
with SP4. You might check the following article, although it doesn't related
directly to import/export issues.

http://support.microsoft.com/default.aspx?scid=kb;en-us;301474

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

>I set up the import text, run it, and when it's done, that message pops up.
>
[quoted text clipped - 8 lines]
>> to
>> > imported a text file delimited by |.

Reply to this Message