Skip navigation.
Home
Freeware and Free & Open Source Software for Proprietary OSes

How To Get Data from MySQL or PostgreSQL to Microsoft Excel

For some reason many people are surprised when I show Microsoft Excel importing data from a MySQL database server using ODBC. If you would like to amaze and amuse your friends by doing this too, head over to Microsoft's Port 25 blog at...

Connecting Office Applications to MySQL and PostgreSQL via ODBC

The blog entry links to a PDF document written by Chris Travers (who also wrote step by step instructions for installing MySQL and PostgreSQL on Microsoft Windows) that gives you step-by-step instructions on importing data from either MySQL or PostgreSQL to Microsoft Excel using ODBC.