How to convert mdb files to excel

Conversion method: First open the file that needs to be operated and select the specified table; then right-click the mouse, select "Export" in the pop-up right-click menu, and click "Excel"; then select "Export" in the pop-up "Export" menu Select the specified file format, specify the name and specify the location; finally click the "Finish" button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Access 2019 version, Dell G3 computer.

As shown in the picture, this is a file with the suffix name .mdb (demo.mdb)

On the premise that the Access database is installed, Double-click the file to open it. The interface after opening is as shown in the figure

Double-click the table on the left side of the window (mdl_zzz_sta_cate), and you can see the table on the right side of the window Content

Right-click the table (mdl_zzz_sta_cate), a selection window will pop up

In the pop-up window, select "Export— —Excel”

The next step is a series of regular operations, such as file naming, file storage location selection, file format

After all selections are completed, click "Finish" and the following interface will appear. You are done. Finally, go to the selected storage location to find your converted file

Recommended tutorial: "sql video tutorial"

The above is the detailed content of How to convert mdb files to excel. For more information, please follow other related articles on the PHP Chinese website!