If you’re like most business professionals, you probably use Microsoft Access to manage your data. But what if you want to use that data in Excel? There are a few ways to do this, but the easiest is to import your Access data into Excel. To do this, open Excel and create a new workbook. Then select the “File” tab and click on “Import.” On the “Import Data” window that opens, select “Microsoft Access.” (If you’re using a different version of Excel, consult your documentation for how to import Access data.) Next, on the “Select Data Source” window that opens, select the database file that contains your Access data. (If you don’t have a database file yet, click on the “Create New Database File” button and enter the name of your database in the “File Name” field.) Finally, on the “Data Options” window that opens, specify how you want Excel to handle your data. You can choose to insert each row of data as it’s imported or to format it according to your preferences. (For more information about importing Access data into Excel, consult your documentation.) ..
Open up a new or existing Excel worksheet that you want to add the data to and click Data Get External Data From Access.
Next, browse to the Access database you want to get table information from and double click.
Now you will be able to scroll to the table within the database you want to add to Excel and double click.
The Import Data dialog box will open up for you to make various selections, in this example we are importing the table data so we can leave the default settings and select the cell to start the data import. Click Ok.
The data from the table will now be shown on the Excel worksheet in the same order as the table.
