Import af Excel til Access

Not sure hwo you are importing, bt if you are using

Docmd.TransferSpreadsheet ...

Then you can include the actual sheet you want to import form in the Range parameter. Just make sure you have a ! charater after the sheet name.

Example:

Docmd.TransferSpreadsheetacImport,acSpreadsheetTypeExcel9, "tblExcel","C:\book1.xls",false,"Sheet2!"

that's solved my problem.

thanks mate.

your welcome and thank you too