How to Extract Data From Access

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Extracting data from Microsoft Access can be done with a few mouse clicks.

Not everyone works with the same data program. At some point, you may face a need to extract information from Microsoft Access and export it into a different file format. Text files are the lingua franca of the data world, but Microsoft Access 2007 also allows you to transfer data to formats that include other Access files, Excel, Word, dBase, Paradox and Lotus, as well as PDF and XML files.


Extracting Data from Microsoft Access

Video of the Day

Step 1

Open Microsoft Access. Run the query you want to extract or open the table.

Video of the Day

Step 2

Save the query or table. Click on the "External Data" tab at the top.


Step 3

Select the format you wish to export. A dialog box will open.

Step 4

Select the folder on your computer where you want the data. Make sure the correct file format is selected. Specify one of three export options. Click on the "OK" button. Your data should export to the proper folder.


Step 5

Navigate to the folder where you exported your data. Make sure that it opens and that all your data is there.




Report an Issue

screenshot of the current page

Screenshot loading...