469,616 Members | 1,620 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,616 developers. It's quick & easy.

Access 2002 3709 Import Error

All,

I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreadsheet method
statement is:

DoCmd.TransferSpreadsheet acImport, , "tblStaging", strFilePath &
"Temp.xls", True, ""

Thanks in advance,
Sarah

Aug 4 '06 #1
1 2147
I suspect the empty string parameter you have specified for Range is causing
the problem, try this.

DoCmd.TransferSpreadsheet acImport, , "tblStaging", strFilePath &
"Temp.xls", True

"SarahK" <sa*******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
All,

I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreadsheet method
statement is:

DoCmd.TransferSpreadsheet acImport, , "tblStaging", strFilePath &
"Temp.xls", True, ""

Thanks in advance,
Sarah

Aug 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Sebastian C. | last post: by
52 posts views Thread by Neil | last post: by
1 post views Thread by ladybug via AccessMonster.com | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.