Sychronization Data in two Access Database

[Edward]

My company has two standalone program that builds on access 2000
running at two different sites (physical location apart), I am just
thinking if there are any effective and easy ways to sychronize the
data in a table (or a few tables) from these two? The two sites are
connected to the broadband internet and can transfer file easily.

From the time being I use my labtop to open the two access database in

two sites each time and do the copy and paste job, which is very time
consuming.

Note : There are no MS Access in the two sites, but got MS Office Excel
2003, I have tried to get the export from dataset functions in the
excel but don't know the way to import the data back to the access. Or
using ODBC, ADO object would also be another clues for me, but yet I
don't have any idea for how to do.

Thanks all in advance.

 

[Larry Daugherty]

How about expressing your issue more clearly? In paragraph1 Access
seems to play. In Paragraph 2 you write that Access doesn't play.
This is a newsgroup devoted to the care and feeding of Access
endeavors so you must believe the solution lies in Access in some way.

HTH