Connect to a PostgreSQL database through ODBC on Excel 2016

sql excel postgresql odbc excel-2016
B F picture B F · Aug 12, 2016 · Viewed 11.3k times · Source

I'm having trouble using ODBC to connect from Excel 2016 to a PostgreSQL database.

I tried to follow this answer, without success, and this solution from MS, without any better results...

Has anyone ever succeeded at this? I saw that Excel 2016 had some troubles with ODBC drivers, but that was like a year ago, so I was wondering if things may be better now?

Thank you for your help.

Answer

Hambone picture Hambone · Aug 12, 2016

My guess is this is a 32/64 bit thing. It's the single biggest issue we've had with setting people up on PostgreSQL within Excel/Access.

Bottom line: if your Excel instance is 32-bit (which is often the case), then you need to use the 32-bit ODBC driver. The latest Pg ODBC driver has both bundled in the same assembly, so the trick is to go into 32-bit ODBC and set up the driver that way.

From there, it should all be straight-forward:

  • Data Tab
  • From Other Data Sources
  • Microsoft Query
  • Select the Data source you just set up

And so on.

Related questions

PostgreSQL Query to Excel Sheet

I need to export some data from PostgreSQL to Excel (quick customer wish), and the last time Excel had serious problems opening or importing my COPYd csv files (line endings, utf-8 encoding, etc), and it took me an hour at …

Read More
Generate sql insert script from excel worksheet

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert script from this excel worksheet?

Read More
How to run a SQL query on an Excel table?

I'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn't null. I could do this pretty easy with SQL, but I have no clue how …

Read More