Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yes, you can do it with odbc in excel. Create and ODBC connection using
the MySQL driver.
(Office XP/Excel XP):
Data -->Import External Data --> New Database Query --> (select your
odbc connection) --> Setup the query (add cols) -Next-> select a col. to
select the data based upon (if any) -Next-> Select a sort col and by (if
any) -Next-> Select Return Data to Microsoft Excel -Finish-
Remember, Excel has a hard limit on the number of rows, (it is not a
database.)
--
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
