Access to Sqlserver transfering ?

I am having Access database in my local system . Values in the access database will be updated for every 5 min .

I am also having Sqlserver database online with the same structure database of Access in my local system .

What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
I hope your database isn't too big. Google around about the DTS packages of SQL Server. You can make one (it defines import/export mechanism), then call it periodically.|||

You can set a flag column in access database with default value 0. If the data is updated set flag to 1.

Then you run a program periodically update the updated data in access to sql server and set all flags to 0.

|||

hi dear ;

i think u mast using datareader object (connected datasource) to get ur data online updated but u mast try to refrishing it.

dont use dataset (disconnected datasource)