DoCmd.TransferSpreadsheet

[arturreter]

Hello,

I wanted to import data from excel to access table via form button.

And I did it using DoCmd.TransferSpreadsheet.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbclients", strFileName, True

Now I want to import data from two different workbook sheets "costumer1" and "costumer2" to one access table. Is there a way to change/modyfy DoCmd.TransferSpreadsheet to do that?

 

[pr2-eugin]

The method DoCmd.TransferSpreadsheet has an argument called Range, use that to specify the Sheet name.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbclients", strFileName, True, "Customer1!"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbclients", strFileName, True, "Customer2!"

 

[arturreter]

It's working now. Thanks man!