Import Error- Search Key not Found

[bfdave]

I'm attempting to import a text file into a new table, but continue to run into "The search key was not found in any record" error. I don't want a search key.... just want a new table! The spec is set up so all the data types are text, and none are indexed.

The text file is a combination of data and header detail, and I can't figure out what I need to do differently.

Please Help!

 

[Andrew Fergus]

Hello and welcome to Mr Excel.
Have a read of this knowledge base article :
http://support.microsoft.com/default.aspx?scid=kb;en-us;301474
If this does not describe / resolve your issue then post a reply.
HTH, Andrew.

 

[bfdave]

Installed the Service Pack, but problem continues.

 

[bfdave]

It was the size of the database (2,095,108KB), couldn't import anymore. Re-imported into new database and compacted.... works again.

Thanks for sending me in the right direction, and welcoming me to Mr Excel!

 

[jlugo]

Resurrecting this thread to see if any other solutions are out there. Tried saving as CSV file then importing but didnt' help.