Import first worksheet regardless of name

[gdesreu]

Does anyone know how to import the first worksheet (regardless of name) of an excel file? The following works but only if the first worksheet is named "testdata". This name will change in every workbook

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbl_importeddata", strPath & strFile, True, testdata$

Thanks

 

[gdesreu]

Does anyone know how to import the first worksheet (regardless of name) of an excel file? The following works but only if the first worksheet is named "testdata". This name will change in every workbook

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbl_importeddata", strPath & strFile, True, testdata$

Thanks

Figured it out, it was a simple as:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbl_lab_results", strPath & strFile, True, sheets1$