First, you need 
and install AccessToPostgres.
AccessToPostgres is a tool to convert Access data to PostgreSQL.
Using AccessToPostgres you can batch export Access tables data to PostgreSQL tables easily and fast.
Batch transfer data from Access tables To PostgreSQL tables
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Open Source.
2. Select Destination.
3. Select tables to import.
4. Import.
More about AccessToPostgres – the tool to move data from Access to PostgreSQL
30-day free trial US$79.00 
Access → PostgreSQL reference
Type mapping
| Value kind | in Access | in PostgreSQL |
|---|---|---|
| Int | Long Integer | integer |
| Bigint | Long Integer | bigint |
| Decimal | Decimal | numeric(p,s) |
| Float | Double | double precision |
| Text | Text(n) | varchar(n) |
| Long text | Long Text | text |
| Date | Date/Time | date |
| Datetime | Date/Time | timestamp |
| Binary | OLE Object | bytea |
| Boolean | Yes/No | boolean |
| JSON | Long Text | jsonb |
Dialect differences
Both Access and PostgreSQL are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.
| Property | in Access | in PostgreSQL |
|---|---|---|
| port | (file-based) | 5432 |
| identifiers | [square brackets] | "double quotes" |
| row limit | SELECT TOP n | LIMIT n |
| dates | Date/Time | timestamp, timestamptz, date, time |
| long text | MEMO | TEXT |
| binary | OLE Object | BYTEA |
Command line
| Side | Command |
|---|---|
| PostgreSQL | pg_dump or COPY ... TO |
| PostgreSQL (load) | COPY ... FROM |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
