excel function update if mysql databse is updated / an inserts hastaken place.
 

Hi,

I'm looking for a manual to make some code for VBA excel. I would like
to make some functions that keep track of the database and when the
database is updated, the results are also updated live and
automatically.

For instance:
I have a table with members

id name something_else


and a query like this: select count(id) from some_table

if an extra row is added, I would like to see that live in excel.
Does anybody know a site where I can start?
Regards,

Matthijs

excel function update if mysql databse is updated / an inserts has taken place.
 

On Mon, 31 Mar 2008 07:38:41 -0700 (PDT), wrote:


I'm looking for a manual to make some code for VBA excel. I would like
to make some functions that keep track of the database and when the
database is updated, the results are also updated live and
automatically.

For instance:
I have a table with members

id name something_else


and a query like this: select count(id) from some_table

if an extra row is added, I would like to see that live in excel.
Does anybody know a site where I can start?
Regards,

Matthijs: I don't think it's possible. You could create a query table in
Excel that points to your MySQL database. Then you could set it's
properties to refresh every minute. Is every minute "live" enough for you?
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com

excel function update if mysql databse is updated / an insertshas taken place.
 

Hi,

thanks for your tip. It is not live enough, so I have to look for some
other solution.
regards,

Matthijs