Importing selective worksheets and files

[mssbass]

I am pretty new to VBA, in fact, I don't know it at all. I am creating a front-end database for the people I report to. I want them to be able to import a spreadsheet we receive annually with volume data.

I want a form with a button (when clicked) allows the user to choose where the Excel spreadsheet is located.

Once the user chooses the spreadsheet, I want an automation to take place behind the scenes. I only want certain tabs from this Excel file to be imported "as separate tables" in access. The tab labeled UPS, FEDEX and DHL are the tabs I want imported (no others).

Thanks

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886