View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default macros to query a database

On Wed, 25 Feb 2009 16:11:08 -0800 (PST), tannu
wrote:

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.


In Excel, Data Get External Data New Database Query.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com