Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create IF function that inserts cells when condition is m | Excel Worksheet Functions | |||
Macro inserts a column but dont update formulas in another sheet! | Excel Programming | |||
Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
Creating a databse from several Excel files | Excel Discussion (Misc queries) | |||
Making A Databse system on Excel? | Excel Discussion (Misc queries) |