I'm trying to import an Excel spreadsheet into Access like I do every month, but this time I keep getting a message saying, "The search key was not found in any record". Any ideas:confused:

Which access version are you using? In the unlikely case that it's 2000 I'd suggest reading here:

http://support.microsoft.com/kb/301474



Also, it's worth reading the solution mentioned in:
http://www.utteraccess.com/forums/printthread.php?Cat=&Board=88&main=249354&type=thread


If you google it, you'll see it's a common bug of sorts but none of it is linked to using Excel, so perhaps you should look at what's changed to your database/spreadsheet since the last import?