By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Access 2002 3709 Import Error

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.