Jacob J. Walker's Blog

Scholarly Thoughts, Research, and Journalism for Informal Peer Review

Archive for January 10th, 2015

Solution to Excel/Access/ODBC to PostgreSQL Integration Problems

without comments

In order to do more in-depth analysis of our student data, we have recently setup ODBC access to our online SIS, which is running on PostgreSQL.  My goal was to have Access connect to the PostgreSQL data source, so I could create queries (views) in access, which I could then import into Excel.  While Excel should easily connect to Access, as they are both Microsoft products, this has NOT been the case. But now that I have been able to figure out how to get it to work, I’m posting the solution for anyone else who might run there head into the same brick wall.

Read the rest of this entry »

Written by Jacob Walker

January 10th, 2015 at 2:40 pm