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

[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?

 

[OfficeDev18 via AccessMonster.com]

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

 

[bpeacock73]

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.

 

[strive4peace]

Hi bpeacock73 (what is your name?)

thank you for sharing this information

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[bpeacock73]

Ben

Hi bpeacock73 (what is your name?)

thank you for sharing this information

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[strive4peace]

thank you, Ben

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*