Linking MySQL Tables to another Database for continual updating

[mattmc97]

Hello all.

I have a Providex database that has a ODBC driver and I can import tables or queries into excel fine. The problem is I have to MANUALLY refresh the excel file DAILY so that the end of day report items are updated from the database into the excel sheet.

What I would like to do is link the necessary tables in Providex to a MySQL table and then run the queries on the MySQL table. In doing so, I would need the MySQL table to constantly refresh with the Providex database or at least make it where I could refresh it periodically throughout the day.

I know that it is possible to link tables in Access to automatically update when the source is changed, is there some of the same functionality in MySQL? I really don't have any experience with MySQL but have some experience with SQL queries from Microsoft Query and ASP webpages. Any examples or webpages that may outline the process would be great as well!

thanks.

mattmc

 

[Bastien]

no, you can run a cron job to update at set intervals. You can also write VBA code behind the excel sheet to refresh itself whenever its opened

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[mattmc97]

Thanks Bastien,

What I do now is pull several different reports into excel and run MS scheduler and it updates everyday using VBA for those reports I need daily. Providex only provides a windows ODBC driver, so I can't use a cron job.

The only thing I have found in mySQL is import database, I never found a place to refresh the data. I guess I could refresh the data periodically throughout the day.

How would I refresh (reimport) the data into Windows mySQL?

thanks.

mattmc

 

[Bastien]

use a scheduled task...same thing just a ms name

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...