Error when importing Excel document

[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

 

[rhartman]

I'm using 97.