Thread: macros to query a database
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tannu tannu is offline
external usenet poster
  
Posts: 10
Default macros to query a database
On Feb 25, 7:35*am, Dick Kusleika wrote:
On Tue, 24 Feb 2009 18:05:18 -0800 (PST), tannu
wrote:



In others words
Is it possible to pick up information from a MySQL database using a
macro in Excel?

http://dev.mysql.com/downloads/connector/odbc/5.1.html

Install the ODBC driver for MySQL and use Data Get External Data to create
a query table on your Excel sheet.
--
Dick Kusleika
Microsoft MVP-Excelhttp://www.dailydoseofexcel.com

Thanks for your reply
I installed "mysql-connector-odbc-5.1.5-win32.msi" on my windows box.
Also i have mysql query browser from where I can query database and
save the results in excel form.
I need the code( macros) that is just enabling the macros should
automatically query the databse and updat the excel sheet.

Can you please let me know.
Thanks
Reply With QuoteReply With Quote