MS Access and MySQL and other sources 1

[VE]

I'm sure the is pretty basic, sorry, I'm really just starting with MySQL (or any SQL)

We have an MS Access based third party product that reads a btreive database and translates it into relational tables in MS access (imports it and refreshes it several times a day). From this we create reports and the tables are linked to other data for other uses. The live data still lives in btrieve (we do not have the option to change this in the near future).

Is it possible to set up some sort of process that will take the data from the access tables and refresh MySQL versions of the same tables a few times a day? Or should we leave it in access, or is there a third option?

We have other data that I'm pretty sure that we can move to MySQL and have it live there, it's just this one group of tables that I'm worried about.

Thank you
VE

 

[r937]

create linked tables in access that link to mysql tables, and just populate them as another step in the same module that runs your refresh of the access tables from btrieve

r937.com | rudy.ca

 

[VE]

Thank you, I'll try that.