Hello everyone, welcome to my Free GIS Tutorial. Today, we are going to learn about the database and today’s topic is how to export Microsoft Access table to the PostgreSQL database. I have been working on a project that utilizes MS Access to store our data. Access has done great so far but there are many missing features that I basically need. For example, I cannot store the polyline and polygon dataset directly to Access. So, I decided to move our database to PostgreSQL.
As you know, PostgreSQL with PostGIS extension is a great combination that stores data as well as the spatial database. We can store common data files and also we can store polygons, polylines and point features to PostgreSQL. I was so excited to fully upgrade my database to PostgreSQL. So in this article, I am going to show you how to export a single table to the PostgreSQL database. Next time, I will show you how to export the whole MS Access database (.accdb) to the PostgreSQL database.
Steps to Export MS Access Tabel to PostgreSQL Database
Step 1. Create a new PostgreSQL ODBC
In order to export an Access table to the PostgreSQL database, we need to set up a new ODBC connection. This ODBC will act as a bridge between MS Access and PostgreSQL. Please read this nice article below to guide you how to create a new PostgreSQL ODBC on Windows 10.
Step 2. Export the table
Now, we are ready to export our table.
- Open the Access database
- Right-click the table and then choose Export
- Click ODBC Database
- Type the table name. You can use the same name or create a different name.
- Select the ODBC data source you created on the previous step
In a few moments, the table should be exported successfully. Check any errors if any. Watch the entire export process in the following video.