Microsoft Access .MDB and .ACCDB File Description

Microsoft Access .MDB is a binary database file format used by pre-2007 versions of Microsoft Access. The .ACCDB format is used in Access 2007 and 2010. Strater can import data from tables and queries in both Access .MDB and .ACCDB formats.

 

Import Options

See Database Tables and Fields Dialog.

 

Export Options

Strater does not currently export Microsoft Access .MDB or .ACCDB files.

 

Microsoft Access (MDB) Import Options Dialog

If the .MDB file contains multiple tables, you can select which table to import in the Choose Table To Load list. The other controls in the dialog show previews of the data that will be imported. See Microsoft Access .MDB Import Options Dialog.

 

64-Bit Access Driver

In order to import Microsoft Access Database (*.mdb, *.accdb) files, you must have the Microsoft Access Database driver installed on your machine. It’s shipped as part of the Microsoft Office suite and comes in 32-bit and 64-bit versions. Installing the 32-bit Microsoft Office suite will install the 32-bit Access Database driver. Installing the 64-bit Microsoft Office suite will install the 64-bit Access Database driver. Unfortunately, Microsoft doesn’t allow BOTH to be installed simultaneously on a 64-bit Windows platform. If you need to import data from Microsoft Access Database files into Golden Software products, you must install the 32-bit version of our product if you have a 32-bit Access Database driver. You must install the 64-bit version of our product if you have a 64-bit Access Database driver. If you don’t need to import Access Database data with our product, you may install either version on a 64-bit Windows platform.

 

See Also

Microsoft Access .MDB Import Options Dialog

File Format Chart