Hi all.

I'm trying to import data from an excel file with the code :

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Temp", "C:\temp\NomFichier.xls", True

Access returns a "Error 3709 : Search key not found" on this line. I tried installing the Jet SP but nothing changed.

I work on Windows XP with Access 2002 (SP2).

Can someone help me please.. ?