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
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
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/
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
- Microsoft Access 1.0 (Jet 1.0)
- Microsoft Access 1.1 (Jet 1.1)
- Microsoft Access 2.0 (Jet 2.0)
- Microsoft Access 2.0 Service Pack (Jet 2.5)
- Microsoft Access 95 (Jet 3.0)
- Microsoft Access 97 (Jet 3.5)
- Microsoft Access 2000/2002/2003 (Jet 4.0)
- Microsoft Access 2007
- Microsoft Access 2010
- Microsoft Access 2013
- Microsoft Access 2016
You can also use your favourite tool
Why use RebaseData?
- Strong security.
- Convert online without installing Microsoft Access.
- Works with Windows, Mac and Linux.
- Use an API to convert your databases.
- Professional support.
Terms
- We don't guarantee for the success or correctness of the conversion
- You are only allowed to convert your own database files
- By using RebaseData, you agree to our general terms