Linked by Thom Holwerda on Fri 9th Jun 2006 11:07 UTC, submitted by Jane Walker
Databases "You might be surprised to know that you can connect Excel to a database, and this isn't limited to databases running Microsoft's SQL. Excel can connect to practically any mainstream database (MySQL, PostgreSQL, Oracle and others), provided that the database offers an ODBC (Open DataBase Connectivity) driver. In this article, you'll learn how to connect MySQL to Excel."
Permalink for comment 132290
To read all comments associated with this story, please click here.
Well...
by Ralf. on Sat 10th Jun 2006 16:30 UTC
Ralf.
Member since:
2005-08-13

since Excel can only display about 65000 rows, this is only suitable for "game" database environments.

Reply Score: 1