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."
Thread beginning with comment 131858
To read all comments associated with this story, please click here.
Well, duh...
by RenatoRam on Fri 9th Jun 2006 13:05 UTC
RenatoRam
Member since:
2005-11-14

people routinely use odbc connections from excel and access to whatever remote databases.
Most users simply use the data without even knowing it resides on an Oracle or AS400 machine, but... ODBC is not really news, is it?

Reply Score: 1

RE: Well, duh...
by jcinacio on Fri 9th Jun 2006 13:39 in reply to "Well, duh..."
jcinacio Member since:
2006-03-12

"You might be surprised to know that you can connect Excel to a database"

Actually, i'm not surprised at all.

If i'm not mistaken, you can do this since at least 97...

Edited 2006-06-09 13:40

Reply Parent Score: 2