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 destination path

STEP 7

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

 path of export data

STEP 8

The status bar shows the process of conversion in percentage.

export complete successfully

STEP 9

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

detailed 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.

closing application

Click here to Download Access to Excel Download Now