Import Excel Sheet

[Guest]

Hi

I have to import an Excel File but in the Excel file I have 4 sheets I have
to import the 3rd Sheet How can I do it:

I use this command but it import the first sheet:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"Tb_Climatique", sNameFile


Thanks

 

[FrankStone]

hi,
seveal ways.
first set a range name for the data on sheet3. access
views range names in xl as tables.
then
1 you can create another docmd command for the new data.
2 you can rename the xl table in the docmd you have.
3 you can go file>get external date>import. file type = xl
here you get the option of creating a new table or
inserting it into an existing table.
4 you can write a mcro and use the tranferspreadsheet
there. here you would have the option of creating and new
table or inserting into an existing table.
regards
Frank