Connecting Office Applications to MySQL and PostgreSQL via ODBC

Connecting Office Applications to MySQL and PostgreSQL via ODBC

  • Comments 4
  • Likes

by MichaelF on April 10, 2007 04:05pm


In cases where business applications have been built on open source databases, it may be necessary to connect other Windows applications, such as Microsoft Access or Excel, to these databases for reporting or business intelligence purposes.

One potential application of this process is to use Excel as a front-end for data analysis.  Data can be pulled from views or tables and then further analyzed, graphed, and the like.  Even pivot tables can be used to create even more powerful reporting solutions.

This how-to walks through this process using Excel as an example application.  Although in this example, the MySQL and PostgreSQL servers are running on Linux, the steps are no different if the software is running on Windows.  These steps are:

1.         Setting up authentication
2.         Installing the ODBC Drivers
3.         Configuring the data source
4.         Importing the data.

Attachment: excerpt_linux_in_a_windows_world.pdf

Comments
  • The attachment doesn't appear to have anything to do with the article and I can't find the remainder of the article.

  • The attachment refers to ",ch03.21937  Page 33  Friday, January 21, 2005  8:13 AM" Chapter 3, SAMBA Basic Configuration? What gives?

    Does anybody read these comments?

  • This should be the right document:

    web.archive.org/.../excelopendbprimer.pdf

  • Mirror: www.filefactory.com/.../excelopendbprimer_pdf

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment