YouTube on MSN

We use Power Query to combine sheets

This video shows how to create a combined PivotTable from multiple Excel worksheets and files. It demonstrates three scenarios and the methods to consolidate data for analysis: - Scenario 1 (0:51) — ...
Ars Technica

Creating an Access Table using Visual Basic

I'm connected to and manipulating a Access Database using a VB frontend. But I'd like to add a simple table with 2 fields and populate it and I'm not sure how to go about doing this, google searches ...