Re: Populate values in an Excel sheet from MySQL

[JamesDR]

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