CODEWITHSUNDEEP
pythonpostgresqlms-accesspsycopg2pyodbc
ArtDijk
ArtDijk

Reputation: 2017

python postgresql ms access driver advice

We are building a datawarehouse in PostgreSQL. We want to connect to different data sources. Most data will come from ms access. We not not python experts (yet :-)). We found several database connectors. We want to use (as much as possible) standard SQL for our queries. We looked at pyodbc pscopg2. Given that we use MS Access and PostgreSQL and want to have the same query syntax and return data types; Which drivers should we use ?

Upvotes: 0

Views: 132

Answers (1)

Chris Travers
Chris Travers

Reputation: 26464

Your query syntax differences will depend on PostgreSQL extensions vs MS Access-specific quirks. The psycodb and pyodbc will both provide a query interface using whatever SQL dialect (with quirks) the underlying db connections provide.

Upvotes: 1

Related Questions