Access Data export to Access DB

J

Joe

Hi out there,
At the moment I have following situation: Data is being entered into Access
DB (2003) in one end and then weekly exported (as two tables in XML) as
e-mail attachment to other end and imported into master DB. It is then
appended into the table with same name.
My question is: how to do this more economically – export only data entered
since last export, do appropriate import and how to automate the process,
export and import.
Any suggestions?
 
Top