Error when importing Excel document

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I received the following error message when importing a
Excel document into my access database.

Run-time error 3709. The search key was not found in any
record.

I use the following line of code.

DoCmd.TransferSpreadsheet transfertype:=acImport,
TableName:="tmpBalance", FileName:="c:\temp\balance 08-04-
03.xls", hasfieldnames:=True, Range:="A:J"

Any clue what is wrong?

Thanks

Don
 
Back
Top