Append local AccessDB to SQL...

Hello, all. I've got an app that is writing data to an Access Database on a local machine (laptop) that is not always connected to a network or internet. i would like some guidance on how I can automate the appending of the data from the laptop to a SQL server once connected. Polling the modem or network card I think I can handle, but I'm having trouble getting the Access db over to SQL. My connection is OK, and I can MANUALLY use the MSAccess Upsize wizard to send the table over, but can I automate this whole deal from VB?? I will need another connection object to ODBC, but any advice on how to do this would be much much appreciated!! :)

-r

You should check out "replication" in the MSDN.

The basic idea is that you have a local copy of your Db on the desktop and periodically update the main database.

Great idea...except the MSDN replication info is sparse and far less than helpful. So, replication is what I need. How 2? Could you be a bit more explanatory, plz?
-r