How to import the certain sheets from excel file?

[sabavno]

Hello,

I want to import certain sheets from the excel spreadsheet into one access table.

I know how to import one sheet:
DoCmd.TransferSpreadsheet acImport, , "Table1", path, True, "Group_Billing!"

But is there a way to import a few sheets?

Thanks.

 

[SBendBuckeye]

If you do DoCmd.TransferSpreadsheet back to back does it append or overwrite? If it overwrites, you might try creating a temporary table to hold the import and then running an append query against it to the destination file in between imports.

Please repost and let me know if either of these suggestions works.

Good LucK!