View Single Post
  #3   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 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-Excel
http://www.dailydoseofexcel.com