Any way to import mysql database info directly into EXCEL

[bobcpg]

just what the topic says.

i want to be able to just open up an MS excel doc and have it pull data for its cells from a mysql database.

ideas?


thanks,

 

[KLin]

1. create ODBC connection to MySQL database
2. Open excel
3. click data
4. click get external data
5. click database query
6. create query to select data
7. click ok to choose which cells to populate.

 

[bobcpg]

Originally posted by: KLin
1. create ODBC connection to MySQL database
2. Open excel
3. click data
4. click get external data
5. click database query
6. create query to select data
7. click ok to choose which cells to populate.

How would i do number 1, from windows xp pro and office xp

EDIT: actually i think i can google number 1, thanks!

 

[EagleKeeper]

Start/Settings/Admin Tools/ODBC Connections