December 1st, 2003, 05:58 AM
I have two tables in a MS Access DB. One set of tables are being pulled down from the web and the other set of tables are the office.
I want for all the web data to be put into the offline DB when refreshing etc.
Is there anyway I can link the two tables so that on refresh, the web data is inputted into the office DB?
December 1st, 2003, 07:07 AM
I'll explain a bit better!
I have a DB. There are 3 tables. I have an online MySQL DB which I also use. I imported these via an ODBC connection and so have 6 DBs:
How can I link Office_1 to Web_1 so that ALL the contents of Web_1 are imported into Office_1 on a refresh etc. Same applies to others.