Excel Guides

Pulling Access Information into Excel

There are a few ways to pull information from an Access database into Excel. One way is to use Microsoft Query. This tool allows you to connect to an Access database and select the data that you want to bring into Excel. To use Microsoft Query, follow these steps:

  1. Open Excel and go to the Data tab.
  2. Click on From Other Sources and then From Microsoft Query.
  3. In the Choose Data Source dialog box, select the Access database that you want to connect to and click OK.
  4. In the next dialog box, select the table or tables that you want to bring into Excel and click OK.
  5. The data from Access will now be displayed in Excel.

Another way to pull information from Access into Excel is to use VBA code. The code below will allow you to select the data that you want to bring into Excel and then create a new workbook with that data. To use this code, follow these steps:

  1. Open the Access database that you want to connect to in Excel.
  2. Open the Visual Basic Editor (press Alt+F11).
  3. Insert a new module (click Insert > Module).
  4. Paste the code below into the module.
  5. Change the range in the code to match the range of data that you want to bring into Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.