How to Import an MDB in OpenOffice

Written by aurelio locsin
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Import an MDB in OpenOffice
(Siri Stafford/Digital Vision/Getty Images)

The MDB format designates a relational database file created by Access, which is the database program of Microsoft Office. The program offers easy-to-use menus and mouse clicks for organising information. However, it does cost money. A free alternative is OpenOffice Base, which can import MDB files.

Skill level:


  1. 1

    Run OpenOffice Base to display the Database Wizard dialogue box. Click “Step 1” if it is not automatically selected.

  2. 2

    Click “Connect to an existing database” and then choose “Microsoft Access” in the database drop-down. Click “Next.”

  3. 3

    Click “Browse” to display an Open file dialogue box. Navigate to the MDB file and double-click to specify it for OpenOffice.

  4. 4

    Click “Finish” to display a “Save As” dialogue box. Enter a name for the imported database. Note that it is saved in OpenOffice (ODF) and not Access (MDB) format. The database appears in OpenOffice Base. Note that the import will read tables, data and relationships, but not forms or reports.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.