How to Export Access Database to Excel

Find out how to convert MS Access database to an Excel spreadsheet with this How it Works section. With the help of SysTools Access to Excel Converter tool, you can now perform conversion of unlimited Access database files to XLS format.

STEP 1

Follow the path: Start » All Programs » SysTools® Access to Excel » SysTools® Access to Excel.

Click on Browse button:

access-to-excel
STEP 2

Open Corrupt MDB File

Browse MS Access File(s) – Selecting Open option will help you browse MDB files from its respective location on system. Select the file and click Open:

open-mdb-file
STEP 3

Click on the Recover button to detect the condition of the file before beginning its conversion.

recover-mdb-file
STEP 4

Click on Finish after the recovery of MS Access database has been performed.

progress-details
STEP 5

Recovered table can be seen in the software panel by clicking on the table name. Click on Export:

recovered-mdb-data
STEP 6

Browse the destination path for saving the recovered database. Click on Browse:

browse-desination-path
STEP 7

Now export the recovered Access database in Excel format file accordingly, after choosing the export option. Click on Export:

path-of-exported-data
STEP 8

The status bar shows the process of conversion in percentage.

export-completed-successfully
STEP 9

An Export detail summary will appear on screen showing the table exported to MS Excel. Click on OK:

detail-summary-of-exported-data
STEP 10

Exit from the application and click Yes on the notification window displayed by the software:

closing-application
STEP 11

View the complete report of the converted database.

recovered-data

Click here to Download Access to Excel Download