EGGER APPS: DATABASE SOFTWARE FOR MACOSPOSTICOJETREADMDB/ACCDB VIEWER FOR MACEGGER APPS JOBSABOUT EGGER APPS EGGER APPS. Postico. A modern database app for your Mac. MDB/ACCDB Viewer. Open Microsoft Access databases on your Mac. Table Tool. An Open Source CSV file editor. Postgres.app. Run a PostgreSQL server on

your Mac.

MDB/ACCDB VIEWER FOR MAC Export to everything. MDB Viewer can export your Access database to pretty much anything. Create Excel workbooks, SQLite databases, CSV files or SQL dumps. Use MDB Viewer to export to Apple Numbers, Filemaker, Bento, Open Office or even your Address Book. The online documentation includes step-by-step guides for exporting to many

applications.

POSTICO – A MODERN POSTGRESQL CLIENT FOR THE MAC Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar — a great choice

for long text.

FIELD TYPES IN MICROSOFT ACCESS FILE FORMATS SUPPORTED BY MDB VIEWER Files created with older versions of Microsoft Access (Access 1.0, Access 2.0) are not supported by MDB Viewer. The only way to open these old files is to first convert them using Access 97, 2000, or 2002/2003. Microsoft Access 2007 and later also don't support these old files anymore. If you have such a database, I can convert them to

a newer

POSTICO 2 PREVIEW

Postico 2 updates itself, so unless you disable automatic updates that should not be an issue. Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can preorder Postico 2. POSTGRES: MIGRATING ACCESS DATABASES TO POSTGRESQL Migrating Access Databases to PostgreSQL. MDB Viewer supports exporting tables to SQL dumps that are compatible with PostgreSQL. To upload the data to a server you must execute the SQL dump with a separate application, for example using pgAdmin.pgAdmin is a free PostgreSQL client application. FILEMAKER: CONVERTING ACCESS DATABASES TO FILEMAKER PRO in the Finder, right click on the Excel file to open with Filemaker Pro. when Filemaker prompts you, select a work sheet (FileMaker will only accept one work sheet at a time) select "First Row contains field names" and save. As a result you have now a new FileMaker Pro DB with one table. To include additional tables from your Access DB you have ALTERNATIVES TO MICROSOFT ACCESS ON THE MAC Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. OPEN OFFICE: CONVERTING ACCESS DATABASES TO OPEN OFFICE Converting Access Databases to Open Office or Libre Office. The only way I found to import data into Open Office 3 was the following procedure: Export all the tables you need as CSV files (International format) and place them in a folder EGGER APPS: DATABASE SOFTWARE FOR MACOSPOSTICOJETREADMDB/ACCDB VIEWER FOR MACEGGER APPS JOBSABOUT EGGER APPS EGGER APPS. Postico. A modern database app for your Mac. MDB/ACCDB Viewer. Open Microsoft Access databases on your Mac. Table Tool. An Open Source CSV file editor. Postgres.app. Run a PostgreSQL server on

your Mac.

MDB/ACCDB VIEWER FOR MAC Export to everything. MDB Viewer can export your Access database to pretty much anything. Create Excel workbooks, SQLite databases, CSV files or SQL dumps. Use MDB Viewer to export to Apple Numbers, Filemaker, Bento, Open Office or even your Address Book. The online documentation includes step-by-step guides for exporting to many

applications.

POSTICO – A MODERN POSTGRESQL CLIENT FOR THE MAC Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar — a great choice

for long text.

FIELD TYPES IN MICROSOFT ACCESS FILE FORMATS SUPPORTED BY MDB VIEWER Files created with older versions of Microsoft Access (Access 1.0, Access 2.0) are not supported by MDB Viewer. The only way to open these old files is to first convert them using Access 97, 2000, or 2002/2003. Microsoft Access 2007 and later also don't support these old files anymore. If you have such a database, I can convert them to

a newer

POSTICO 2 PREVIEW

Postico 2 updates itself, so unless you disable automatic updates that should not be an issue. Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can preorder Postico 2. POSTGRES: MIGRATING ACCESS DATABASES TO POSTGRESQL Migrating Access Databases to PostgreSQL. MDB Viewer supports exporting tables to SQL dumps that are compatible with PostgreSQL. To upload the data to a server you must execute the SQL dump with a separate application, for example using pgAdmin.pgAdmin is a free PostgreSQL client application. FILEMAKER: CONVERTING ACCESS DATABASES TO FILEMAKER PRO in the Finder, right click on the Excel file to open with Filemaker Pro. when Filemaker prompts you, select a work sheet (FileMaker will only accept one work sheet at a time) select "First Row contains field names" and save. As a result you have now a new FileMaker Pro DB with one table. To include additional tables from your Access DB you have ALTERNATIVES TO MICROSOFT ACCESS ON THE MAC Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. OPEN OFFICE: CONVERTING ACCESS DATABASES TO OPEN OFFICE Converting Access Databases to Open Office or Libre Office. The only way I found to import data into Open Office 3 was the following procedure: Export all the tables you need as CSV files (International format) and place them in a folder JETREAD - EGGERAPPS.AT jetread is a single executable. Just unzip it somewhere and execute it: ./jetread. This will print basic usage instructions, which may or may not be accurate. To list tables in a database file, use the following command: ./jetread database.mdb list-tables. To read a table use the following command: ./jetread database.mdb export TABLENAME. FILE FORMATS SUPPORTED BY MDB VIEWER Files created with older versions of Microsoft Access (Access 1.0, Access 2.0) are not supported by MDB Viewer. The only way to open these old files is to first convert them using Access 97, 2000, or 2002/2003. Microsoft Access 2007 and later also don't support these old files anymore. If you have such a database, I can convert them to

a newer

POSTICO USER GUIDE

Press ⌘P and type a part of a table name to show a list of matching tables, then press enter to navigate to the the matching table. #228. Postico now supports tabs on macOS Sierra. Press ⌘T to open a new tab. #44. You can now select PEM files for TLS client certificates

#237.

MYSQL: MIGRATING ACCESS DATABASES TO MYSQL Step by Step. Click the "Export SQL" button if you want to export all tables or select some tables in the sidebar and choose "Export selected tables to SQL". from the File menu. Select the "MySQL" format, and choose whether to export data, structure, or both. Select the target database from the database popup.

POSTICO USER GUIDE

Using the Table DDL View. The DDL (data definition language) view renders the SQL statements necessary to re-create the selected table/view from scratch. It also works if the table is new, or changes are made in the Structure editor. In case of pending changes, the DDL view renders multiple sections: SQL statements to create the current

version.

MDB VIEWER HELP

Troubleshooting. If you encounter a problem with MDB Viewer, and neither this documentation nor the list of known issues can help you, please don't hesitate to contact me. You can reach me via email: jakob@eggerapps.at . I personally answer emails, usually within 12-24

hours. Help Index.

POSTICO USER GUIDE

Importing and Exporting data in Postico Copy & Paste. Copy & Paste is the most convenient way to import and export data in Postico. Postico, like most other Mac apps, copies tabular data in "Tab Separated Values" (TSV) format: columns are separated by tabs, and row are separated with newlines. VIEWING ACCESS DATABASES WITH MDB VIEWER FOR MAC Viewing Access databases with MDB Viewer for Mac Basics. When you open a database with MDB Viewer, you will immediately see a list of tables in the sidebar on the left. EXCEL: CONVERTING ACCESS DATABASES TO MICROSOFT EXCEL Exporting XLS files. 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.

POSTICO USER GUIDE

There are two ways to connect to a local PostgreSQL server: Using a TCP connection ( localhost, 127.0.0.1, ::1) Using a Unix socket connection ( /tmp/.s.PGSQL) Postico always uses TCP connections. Postico can't use socket connections because sandboxed apps are not allowed to access unix sockets outside their sandbox. EGGER APPS: DATABASE SOFTWARE FOR MACOSPOSTICOJETREADMDB/ACCDB VIEWER FOR MACEGGER APPS JOBSABOUT EGGER APPS EGGER APPS. Postico. A modern database app for your Mac. MDB/ACCDB Viewer. Open Microsoft Access databases on your Mac. Table Tool. An Open Source CSV file editor. Postgres.app. Run a PostgreSQL server on

your Mac.

POSTICO – A MODERN POSTGRESQL CLIENT FOR THE MACCHANGELISTABOUTEGGER APPSREPORTING BUGSLEGACY DOWNLOADSUSER GUIDE Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar — a great choice

for long text.

MDB/ACCDB VIEWER FOR MAC Export to everything. MDB Viewer can export your Access database to pretty much anything. Create Excel workbooks, SQLite databases, CSV files or SQL dumps. Use MDB Viewer to export to Apple Numbers, Filemaker, Bento, Open Office or even your Address Book. The online documentation includes step-by-step guides for exporting to many

applications.

FILEMAKER: CONVERTING ACCESS DATABASES TO FILEMAKER PRO in the Finder, right click on the Excel file to open with Filemaker Pro. when Filemaker prompts you, select a work sheet (FileMaker will only accept one work sheet at a time) select "First Row contains field names" and save. As a result you have now a new FileMaker Pro DB with one table. To include additional tables from your Access DB you have FIELD TYPES IN MICROSOFT ACCESS POSTGRES: MIGRATING ACCESS DATABASES TO POSTGRESQL Migrating Access Databases to PostgreSQL. MDB Viewer supports exporting tables to SQL dumps that are compatible with PostgreSQL. To upload the data to a server you must execute the SQL dump with a separate application, for example using pgAdmin.pgAdmin is a free PostgreSQL client application.

POSTICO 2 PREVIEW

Postico 2 updates itself, so unless you disable automatic updates that should not be an issue. Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can preorder Postico 2. OPEN OFFICE: CONVERTING ACCESS DATABASES TO OPEN OFFICE Converting Access Databases to Open Office or Libre Office. The only way I found to import data into Open Office 3 was the following procedure: Export all the tables you need as CSV files (International format) and place them in a folder

POSTICO USER GUIDE

Using the Table DDL View. The DDL (data definition language) view renders the SQL statements necessary to re-create the selected table/view from scratch. It also works if the table is new, or changes are made in the Structure editor. In case of pending changes, the DDL view renders multiple sections: SQL statements to create the current

version.

ALTERNATIVES TO MICROSOFT ACCESS ON THE MAC Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. EGGER APPS: DATABASE SOFTWARE FOR MACOSPOSTICOJETREADMDB/ACCDB VIEWER FOR MACEGGER APPS JOBSABOUT EGGER APPS EGGER APPS. Postico. A modern database app for your Mac. MDB/ACCDB Viewer. Open Microsoft Access databases on your Mac. Table Tool. An Open Source CSV file editor. Postgres.app. Run a PostgreSQL server on

your Mac.

POSTICO – A MODERN POSTGRESQL CLIENT FOR THE MACCHANGELISTABOUTEGGER APPSREPORTING BUGSLEGACY DOWNLOADSUSER GUIDE Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar — a great choice

for long text.

MDB/ACCDB VIEWER FOR MAC Export to everything. MDB Viewer can export your Access database to pretty much anything. Create Excel workbooks, SQLite databases, CSV files or SQL dumps. Use MDB Viewer to export to Apple Numbers, Filemaker, Bento, Open Office or even your Address Book. The online documentation includes step-by-step guides for exporting to many

applications.

FILEMAKER: CONVERTING ACCESS DATABASES TO FILEMAKER PRO in the Finder, right click on the Excel file to open with Filemaker Pro. when Filemaker prompts you, select a work sheet (FileMaker will only accept one work sheet at a time) select "First Row contains field names" and save. As a result you have now a new FileMaker Pro DB with one table. To include additional tables from your Access DB you have FIELD TYPES IN MICROSOFT ACCESS POSTGRES: MIGRATING ACCESS DATABASES TO POSTGRESQL Migrating Access Databases to PostgreSQL. MDB Viewer supports exporting tables to SQL dumps that are compatible with PostgreSQL. To upload the data to a server you must execute the SQL dump with a separate application, for example using pgAdmin.pgAdmin is a free PostgreSQL client application.

POSTICO 2 PREVIEW

Postico 2 updates itself, so unless you disable automatic updates that should not be an issue. Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can preorder Postico 2. OPEN OFFICE: CONVERTING ACCESS DATABASES TO OPEN OFFICE Converting Access Databases to Open Office or Libre Office. The only way I found to import data into Open Office 3 was the following procedure: Export all the tables you need as CSV files (International format) and place them in a folder

POSTICO USER GUIDE

Using the Table DDL View. The DDL (data definition language) view renders the SQL statements necessary to re-create the selected table/view from scratch. It also works if the table is new, or changes are made in the Structure editor. In case of pending changes, the DDL view renders multiple sections: SQL statements to create the current

version.

ALTERNATIVES TO MICROSOFT ACCESS ON THE MAC Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases.

ABOUT EGGER APPS

We have better features. Our products are designed with a meticulous attention to detail. We're a small team based in Linz, Austria. Jakob Egger studied physics, but became a software developer. He spends most of his time working on Postico and answering customer emails. email jakob@eggerapps.at. Martin Jan Köhler studied computer science. MDB/ACCDB VIEWER FOR MAC Export to everything. MDB Viewer can export your Access database to pretty much anything. Create Excel workbooks, SQLite databases, CSV files or SQL dumps. Use MDB Viewer to export to Apple Numbers, Filemaker, Bento, Open Office or even your Address Book. The online documentation includes step-by-step guides for exporting to many

applications.

JETREAD - EGGERAPPS.AT jetread is a single executable. Just unzip it somewhere and execute it: ./jetread. This will print basic usage instructions, which may or may not be accurate. To list tables in a database file, use the following command: ./jetread database.mdb list-tables. To read a table use the following command: ./jetread database.mdb export TABLENAME.

POSTICO USER GUIDE

Press ⌘P and type a part of a table name to show a list of matching tables, then press enter to navigate to the the matching table. #228. Postico now supports tabs on macOS Sierra. Press ⌘T to open a new tab. #44. You can now select PEM files for TLS client certificates

#237.

MDB VIEWER HELP

Troubleshooting. If you encounter a problem with MDB Viewer, and neither this documentation nor the list of known issues can help you, please don't hesitate to contact me. You can reach me via email: jakob@eggerapps.at . I personally answer emails, usually within 12-24

hours. Help Index.

VIEWING ACCESS DATABASES WITH MDB VIEWER FOR MAC Basics. When you open a database with MDB Viewer, you will immediately see a list of tables in the sidebar on the left. The rest of the window is occupied by the currently selected table. You can sort the table by clicking the column titles (click twice to sort in descending order). If a table contains lots of text or images, you can open a IMPORTING CONTACTS FROM ACCESS DATABASES TO IPHONE Select the table with contact information in MDB Viewer. Click the "Export CSV" button, or select "CSV Export" from the File menu. Save the table using the international CSV format and UTF-8 encoding. Open the Contacts application (called Address Book before OS X 10.8) Choose Import from the File menu. In the open dialog, make sure you select

POSTICO USER GUIDE

Working with Connection Favorites. To connect to a PostgreSQL server with Postico, you must first create a favorite. The favorite window is shown on launch, but you can always bring it SQLITE: CONVERTING ACCESS DATABASES TO SQLITE Converting data to SQLite could not be any easier: Just click the "Export SQLite" button in the toolbar. You can export either all tables or only selected tables. (Press ⌘ or ⇧ while clicking to select more than one table in the sidebar) MDB Viewer transfers all

data to the SQLite

POSTICO USER GUIDE

Importing and Exporting data in Postico Copy & Paste. Copy & Paste is the most convenient way to import and export data in Postico. Postico, like most other Mac apps, copies tabular data in "Tab Separated Values" (TSV) format: columns are separated by tabs, and row are separated with newlines.

EGGER APPS

POSTICO

A modern database app for your Mac

MDB/ACCDB VIEWER

Open Microsoft Access databases on your Mac

TABLE TOOL

An Open Source CSV file editor.

POSTGRES.APP

Run a PostgreSQL server on your Mac.

JETREAD

Read Access files from the command line. About Egger Apps   〜   Privacy 〜   Contact: support@eggerapps.at