7 ways to open an MDB file without Microsoft Access

The quickest way to open an MDB file without Microsoft Access is to import its tables into Excel with Data > Get Data > From Database > From Microsoft Access Database.

If you do not have Excel, LibreOffice Base, a dedicated viewer, an online service, a text editor or a friend's copy of Access can also get the data out, and buying Access remains the option when you need the forms and reports too.

7 ways to open an MDB file without Microsoft Access
Excel's Navigator lists every table in an Access database; tick several, then choose Load or Transform Data to bring them into sheets. (Image: Microsoft)

7 ways to open an MDB file without Microsoft Access

Each route gets you a different amount of the database. Pick the row that matches what you have installed and what you need from the file.

Method Cost What you get Best for
Import it with Excel Included with Excel Tables and saved queries as sheets Reading or analysing the data
Use LibreOffice Base Free Tables and queries inside a database window No Microsoft Office on the PC
Use a third-party MDB viewer Varies Read-only view of tables Browsing many old files
Use an online MDB service Varies Tables exported to CSV or a spreadsheet One file, no software installed
Use a text editor Free Readable text fragments only Checking what a file contains
Use someone else's Access Free if you can borrow it Full export or conversion to .accdb Keeping forms, reports and macros
Buy Access Microsoft 365 or Access 2024 Everything, including editing Working with the database long term

Only Access itself runs the forms, reports, macros and VBA code saved in an MDB file. Every other route gives you the tables and, at best, the queries.

Import it with Excel

Excel reads Access databases through Power Query. Each table you load lands in a worksheet, where you can sort, filter and save it as an Excel file.

  1. Open Excel and create a blank workbook.
  2. Select Data > Get Data > From Database > From Microsoft Access Database.
  3. In the Import Data dialog, browse to the .mdb file, select it, and select Open.
  4. In Navigator, select a table or query in the left pane to preview it on the right.
  5. Select Load to drop the data into worksheets, or Transform Data to clean it first in Power Query Editor.
  6. Save the workbook with File > Save As so you no longer depend on the MDB file.

The import is read-only. Changes you make in Excel do not write back to the MDB file. Power BI Desktop uses the same Access database connector if you want charts instead of sheets.

Open an MDB file in Excel with Get Data From Microsoft Access Database
On the Data tab, open Get Data, point to From Database and pick the Access option to browse to the .mdb file. (Image: Microsoft)

Use an open source alternative to Access

LibreOffice Base is the free, open source database app in the LibreOffice suite. Its Database Wizard can connect to an existing Microsoft Access file and show its tables.

  1. Install LibreOffice from libreoffice.org and open it.
  2. Choose File > New > Database to start the Database Wizard.
  3. Select Connect to an existing database, choose Microsoft Access in the Database type list, and select Next.
  4. Next to Microsoft Access database file, select Browse, pick the .mdb file, and select Next.
  5. Choose No, do not register the database unless you want it in mail merges, keep Open the database for editing ticked, and select Finish.
  6. Save the small .odb file that LibreOffice asks for. It stores the connection, not a copy of your data.
  7. In the database window that opens, double-click a table to view its records.

If the Microsoft Access connection fails, the Base help page for the Microsoft Access connection links to a LibreOffice wiki article on connecting to Access databases.

Open an MDB file in LibreOffice Base through the Database Wizard
Switch the choice to Connect to an existing database, then pick Microsoft Access from the database type list beneath it. (Image: books.libreoffice.org)

Use a third-party MDB viewer

Small viewer apps open MDB files without Access or Office. They suit people who receive old databases regularly and only need to look inside them.

  1. Download the viewer only from its developer's own website, not from a download portal.
  2. Check that the viewer lists support for your file's Access version, such as Access 97 or Access 2000-2003 .mdb files.
  3. Make a copy of the MDB file and open the copy, so a crash cannot damage the original.
  4. Open the file in the viewer's read-only mode if it offers one.
  5. Export the tables you need to CSV or Excel format from the viewer's export menu.

If a viewer reports a missing Access driver or provider, install the free Microsoft 365 Access Runtime. It includes the Access Database Engine and its Microsoft Access Driver (*.mdb, *.accdb).

Use an online MDB opening service

Online converters accept an MDB upload and return the tables as CSV or spreadsheet files. Nothing is installed, but your data leaves your PC.

  1. Check the file for personal, customer or financial data. If it holds any, use an offline method instead.
  2. Read the service's privacy policy for how long it keeps uploaded files.
  3. Upload a copy of the MDB file and choose CSV or XLSX as the output format.
  4. Download the converted tables and open them in Excel, Google Sheets or LibreOffice Calc.
  5. Delete the uploaded file from the service if it offers a delete option.

Check the upload size limit before you send a large database, and remember that the service sees every record in the file.

Use a text editor

An MDB file is a binary database, so Notepad shows mostly unreadable symbols. Short text values and object names can still appear as plain words, which is enough to tell what a mystery file contains.

  1. Make a copy of the MDB file.
  2. Right-click the copy and select Open with > Notepad.
  3. Press Ctrl + F and search for a name, a product or another word you expect in the data.
  4. Close Notepad without saving. Saving the file from a text editor corrupts it.

This method never gives you rows and columns. Use it to identify a file, then pick another method to read it.

Convert it with (someone else’s) Access

A colleague, school or library PC with Access can turn the MDB file into something you can open. Export the tables to Excel, or save the whole database in the newer .accdb format.

  1. Open the MDB file in Access with File > Open.
  2. In the Navigation Pane, select the table or query you want.
  3. On the External Data tab, in the Export group, select Excel.
  4. In the Export – Excel Spreadsheet dialog, check the file name and pick a File Format.
  5. Tick Export data with formatting and layout to keep the column formatting.
  6. Select OK, then repeat for each table you need.
  7. To keep the whole database, choose File > Save As > Save Database As, pick the Access (.accdb) type, and save.

Access 2013 and later cannot convert an Access 97 file directly. That file has to go through Access 2003 first, using Tools > Database Utilities > Convert Database > To Access 2002-2003 file format.

Consider buying Access

Buy Access when you need the forms, reports, macros or VBA code, or when you must keep editing the database. No other method runs those parts of an MDB file.

Option What you get Good to know
Microsoft 365 subscription The latest Access, kept up to date A one-month free trial covers a single job
Access 2024 one-time purchase The current standalone version Compatible with Windows 11
Microsoft 365 Access Runtime Free; runs finished Access apps All design tools are removed or disabled

Access is a Windows PC app only, so Mac users need one of the other methods or a Windows PC. A Microsoft Access free trial is enough for a one-off export, and knowing what Microsoft Access does helps you decide whether a subscription is worth it.

Buy Microsoft Access to edit reports like this Yearly Sales Report
Report and form designs inside an MDB file only open in Access itself; Excel and LibreOffice reach just the tables. (Image: Microsoft)

What is an MDB file?

MDB is the database format used by Microsoft Access before Access 2007. One file holds the tables, queries, forms, reports and macros together.

MDB fact Detail
Created by Access 97, Access 2000 and Access 2002-2003, among older versions
Replaced by .accdb, the default format starting with Access 2007
Opens in current Access Access 2000 and 2002-2003 files open normally
Access 97 files Access 2013 and later cannot convert them directly
Access 2.0 and Access 95 files Access 2007 was the last version that could open or import them
Still used for Replication and user-level security, which .accdb does not support
Driver that reads it Microsoft Access Driver (*.mdb, *.accdb) in the Access Database Engine

A file ending in .accdb opens with the same Excel and LibreOffice steps above. The .mdb and .accdb names only tell you which Access generation saved the file.

MDB file not opening in Excel or Power BI

Excel, Power BI Desktop and most viewers read MDB files through the Access Database Engine. Most errors mean that engine is missing, hidden or the wrong bit version.

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered"

Power BI Desktop is 64-bit, but the Access Database Engine on the PC is 32-bit, usually because 32-bit Office is installed.

  1. Make sure you run the 64-bit Power BI Desktop, which is the only version available.
  2. Install the 64-bit Microsoft 365 Access Runtime, which includes the Access Database Engine.
  3. If the runtime will not install alongside 32-bit Office, replace Office with the 64-bit edition.
  4. Import the MDB file again.

"Provider cannot be found" or the Access driver is missing in another app

An older Click-to-Run install of Office keeps the Access Database Engine inside Office, out of reach of other programs.

  1. Update Microsoft 365 Apps to Version 2009 or later, which exposes the engine to other apps.
  2. On Office 2016 or 2019 volume-licensed Click-to-Run, upgrade to Office LTSC 2021 or install the Microsoft Access 2013 Runtime.
  3. On a PC without Office, install the free Microsoft 365 Access Runtime.
  4. Open the MDB file in the app again.

Old MDB file from Access 2.0, Access 95 or Access 97 will not convert

Current versions of Access dropped support for those early formats.

  1. For an Access 97 file, open it in Access 2003 and convert it to the 2002-2003 format.
  2. For an Access 2.0 or Access 95 file, convert it in Access 2007, or in Access 2000-2003 first.
  3. Open the converted file in current Access and save it as .accdb.
  4. Import the converted file into Excel or LibreOffice if you still do not want to use Access.
MDB file not opening because the Microsoft Access Driver is missing
The 32-bit ODBC Data Source Administrator lists the Access driver (*.mdb, *.accdb) but warns the driver does not exist. (Image: Microsoft)

MDB file FAQ

Can Excel open an MDB file?

Yes. In Excel select Data > Get Data > From Database > From Microsoft Access Database, pick the .mdb file, and load the tables you want from Navigator. Excel imports a read-only copy of the data, not the forms or reports.

Is there a free Microsoft Access viewer?

Microsoft offers the free Microsoft 365 Access Runtime, which runs finished Access applications with every design tool removed or disabled. It also installs the Access Database Engine that Excel, Power BI and many viewers use to read MDB files.

Can LibreOffice open MDB files?

Yes. LibreOffice Base connects to Microsoft Access files through its Database Wizard: choose File > New > Database, select Connect to an existing database, choose Microsoft Access, and browse to the .mdb file. The tables then open in Base.

What is the difference between MDB and ACCDB?

MDB is the Access format used before Access 2007, and ACCDB has been the default since Access 2007. ACCDB files cannot be opened by Access versions before 2007, while MDB still supports replication and user-level security, which ACCDB dropped.

Can I open an MDB file on a Mac?

Microsoft Access is available for Windows PCs only, so a Mac needs another route. An online MDB service, a Mac viewer from its developer's site, or a Windows PC running Excel or Access can extract the tables.

How do I convert an MDB file to Excel?

Import the tables into Excel with Get Data > From Database > From Microsoft Access Database, then save the workbook. In Access, you can instead select a table and use External Data > Export > Excel to write it straight to a workbook.

Why does my MDB file show strange symbols in Notepad?

An MDB file is a binary database, not a text file, so Notepad shows its raw bytes as symbols. Only short text values and object names appear as words. Close the file without saving, because saving from Notepad corrupts it.

It’s all about that (data) base

Import the MDB file into Excel if you have it, use LibreOffice Base if you do not, and borrow or buy Access only when you need the forms, reports or macros inside the file. The tables are almost always what people need from an old MDB file, and Excel and LibreOffice reach them for free. Everything else in the file only runs in Access.

Philip Celasco

Philip is a Texas-based technology writer and IT administrator at Techdows.com with more than 10 years of experience creating practical content for everyday users and professionals. He specializes in web browsers, particularly Chromium-based platforms such as Google Chrome, Microsoft Edge, Brave, and Opera. Through his work as an IT administrator, Philip has hands-on experience managing devices, configuring browser policies, troubleshooting software and network issues, and helping people resolve problems that affect productivity and security. His articles are based on practical testing and real-world technical experience. He covers browser settings, extensions, performance problems, privacy controls, security features, and Windows troubleshooting. Outside work, Philip enjoys the quieter side of life in Texas and stepping away from the screen when he can. He has two kids, two cats and loves to play golf with his mother during the weekends.

Leave a Reply

Your email address will not be published. Required fields are marked *