Yes, there is . . . you just need to add to the end of the properties you already have to specify a certain sheet and even a certain range if need be.
Example: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "MigData", TxtFilename, True, "MyMainSheet!A7:U65536"
NOTE: This does not work with sheets created in older versions of excel.
It will have to have been created in Excel97 or Later and must be at least version 5.0