transfespreadsheet question

[cmz21]

Hello,
I am using transferspreadsheet to load an access table from an excel spreadsheet. It is working fine except for one thing. I want to load a second table from another worksheet within the workbook I am in. Is this possible? I switch worksheets before I use transferspreadsheet, but it seems to keep using the first sheet in the workbook.

Can I do what I want to do or am I going to have to keep reordering the worksheets?

Thanks

 

[cmz21]

Found the Answer.
Here is the line of code I used -


DoCmd.TransferSpreadsheet transfertype:=acImport, TableName:="tblYour_Table_Name", FileName:="C:/Path/plus/filename.xls", Hasfieldnames:=True, Range:="Retiree Dental!", SpreadsheetType:=5


Thanks