Import a particular excel sheet from list of sheets in workbook using Access VBA

[riaarora]

I'm importing data from Excel to Access using Access VBA which works fine that sheet name is first sheet in workbook. However, if multiple sheets exists in the workbook and that particular sheet can be 2 sheet, 3 sheet or any sheet. In that case how to search particular sheet name and import in access. Below is the code I have used for importing the data.

    objAccess.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
    sTmpTableName, sInput_Dir & "\" & sInputFileName, True, sFile1Wks & "!"

[June7]

Code looks good to me. Should import the named sheet no matter what order it is in the workbook. What happens when you run it?

[riaarora]

Seems it's working fine. Thanks