Convert Access to Postgres online

Input file

Our API uses a Microsoft Access database file (.MDB or .ACCDB) as input. Files with .MDB extension are typically created by Microsoft Access up to version 2003, while .ACCDB files are created by later versions.

Max file size for web uploads: 50 GB
Register to upload big files via Amazon S3.

Output file

The API will return a ZIP archive that contains a .SQL file. This .SQL is a PostgreSQL dump file and can be restored into your PostgreSQL installation.

Conversion methods

Using our Java tool

Download the RebaseData client Java tool . To convert your database using RebaseData, run the following command:

                    java -jar client-0.0.5.jar convert --output-format=postgresql database.mdb/accdb output-dir/
                
Using CURL

Replace database.mdb/accdb with the path to the database you want to convert.
The file output.zip will contain a PostgreSQL data.sql file with your data or the error message if something went wrong.

curl -F files[]=@database.mdb/accdb 'https://www.rebasedata.com/api/v1/convert?outputFormat=postgresql&errorResponse=zip' -o output.zip

How long does it take?

The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.

Supported versions of Microsoft Access

You can also use your favourite tool

Why use RebaseData?

Terms