convert postgresql db into Microsoft Access db with python

Question

How to convert a existing postgresql db into a Microsoft Access db with python?

I want to convert my postgresql db into a Microsoft Access db. There are many possible solutions, like transfer table by table and inside the tables row by row.

But which of the solution mide be the best in terms of performance?

Why? That is step backwards. Why not just set up linked tables in Access? — Adrian Klaver
– Adrian Klaver, Commented Apr 12, 2022 at 16:22

Gustav · Accepted Answer · 2022-04-12 17:23:27Z

3

Install the ODBC driver and link the tables from PostgreSQL
Mark the link tables and choose Convert to local table
(Optional) Go to Database Tools, Access Database, and select to split the database to have the tables in an external Access database

answered Apr 12, 2022 at 17:23

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

convert postgresql db into Microsoft Access db with python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related