Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    importing txt - the search key was not found'error (2003)

    Hi,

    I got "The search key was not found in any record" when attempting to import a text file. I have some specs set up when it comes to delimiting the file. The error message didn't pops up until I clicked "Finish" button. This is a critical issue. I cannot continue the work I need to do because of this error!!

    Please help.

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: importing txt - the search key was not found'error (2003)

    Make sure that contents of the text file are valid. The error message that you mention will occur if there are two columns with the same name, for example.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: importing txt - the search key was not found'error (2003)

    Thanks, Hans.

    But there's no column name in my txt file. I don't think there's any duplicate fields name in the Import sepc since the Access will stop you if you have any duplicate fields.

    The contents of the text file should be valid since I can import it with default delimite.

    Any other ideas?

    Thanks,

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: importing txt - the search key was not found'error (2003)

    If you can import the text file, try creating the import specification again.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: importing txt - the search key was not found'error (2003)

    Thanks, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •