The search key was not found in any record. (Error 3709)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I never had this error before.

This hapens now in this instruction:

DoCmd.TransferSpreadsheet acImport, 8, "NewTable", Me.txtFilename, True, ""

Is it an access problem resolving with a simple shut down?

My application always run without problem with DoCmd.TransferSpreadsheet.

Any ideias?
 
Since the Range is optional, the last "" in your statement is useless, and it
might be confusing to Access. I suggest you remove it and try again.

Sam
 
I have recently had the same problem.
I fixed it by selecting 'False' instead of 'True' and changing the range to
NOT select the headings.
I think that if any of your headings have the same name, you will get this
error.
I assume the other fix would be to make sure your headings are all different.
 
Back
Top