Microsoft Access .MDB and .ACCDB Import Options Dialog

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.

Database Tables and Fields Dialog

In the worksheet, select File | Import to import a .MDB or .ACCDB file. The Database Tables and Fields dialog opens when you select a database file to import into Strater.

The Database Tables and Fields dialog appears when you load a database table into Strater.

Choose a table to load

This sections lists all tables that are in the database file. Highlight the specific file to import. When a file is selected its contents appear in the next two fields.

Available fields in the table

This section lists all the fields in the selected file. This section is read-only.

Preview of the table content

This section displays a preview of the contents of the selected file. This section is read-only.