Access 2002 3709 Import Error

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / General 1 / August 2006

Access 2002 3709 Import Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SarahK - 04 Aug 2006 18:12 GMT

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

Reply to this Message

NthDegree - 31 Aug 2006 15:43 GMT

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

> All,
>
[quoted text clipped - 7 lines]
> Thanks in advance,
> Sarah

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.