MDB Viewer Download Buy Now Also available on the
Mac App Store

MDB Viewer requires OS X 10.6 or later. The free trial is fully functional except for export limitations.
© 2011-2017 Jakob Egger

Help Index

Converting Access Databases to Microsoft Excel

Exporting XLS files

Excel Export Dialog

Just click the "Export XLS" toolbar button to export the database to an Excel workbook. You can choose to export all tables, or just the tables selected in the sidebar. (Press ⌘ or ⇧ while clicking to select more than one table in the sidebar) MDB Viewer supports both the older XLS and the newer XLSX file format.

MDB Viewer exports every table as a separate work sheet inside your Excel file. Due to limitations of the XLS file format, tables with more than 50000 rows are split up into multiple work sheets containing 50000 rows each. The XLSX format has a larger limit, so tables are split into sheets of one million rows.

When exporting to Excel, newlines are replaced by spaces. Data from OLE fields, such as images and other attachments, are not exported.

Alternatives for converting to Microsoft Excel

Copy & Paste

This method is so simple that one might not even think of it: Just select the rows you need (or select all using ⌘A), and copy and paste them into Excel.

The CSV file format

Alternatively, you can export your tables as CSV and import those into Excel. (Not recommended)

How Microsoft Excel handles CSV files depends on your region setting in System Preferences. For example, if you set your region to “United States”, Excel will only expect International CSV files. If you set your region to “Germany”, Excel will expect Continental CSV files.

Excel opens CSV files with the MacRoman encoding.

Excel does not allow line breaks inside fields, so make sure you deselect that option.

For more details on CSV see the section on Exporting Access databases to CSV.

Help Index

Questions? Contact Jakob Egger.