What is an MDB (or ACCDB) file?

Microsoft Access stores a database (its tables, queries, forms and reports) in a single file with the extension .mdb or .accdb. Access 2007 introduced the .accdb format; earlier versions use .mdb. Without Access installed, such a file is hard to open, so this tool gets your data out of it.

What do I get?

• The list of tables with their number of rows, and the first 100 rows of each table on the result page.
• All tables as one Excel file (.xlsx), one sheet per table. Numbers and dates are real numbers and dates in Excel.
• Each table as a CSV file (UTF-8, comma-separated), and all of them as a ZIP.
• All tables as an SQLite database, and as SQL dumps for MySQL/MariaDB and PostgreSQL: CREATE TABLE with the column types and primary keys, then the rows. Empty values become NULL. The dumps don't delete existing tables: import them into a new, empty database.

Only the data of the tables is exported, not queries, forms, reports or macros. Pictures and other binary data (OLE objects) are left empty; of attachment fields, you get the file names. Linked tables, whose data is in another file, are left out.

Supported Access versions

.mdb and .accdb files of Access 97 to Access 2019 and Microsoft 365, also databases protected with a password (enter it before you choose the file). Not supported: Access 1.0 and 2.0.

Limits

You can upload databases of up to 100 MB. An Excel sheet holds at most 1,048,576 rows: for larger tables, and for very large databases, there is no Excel file, only the CSV files.