I think this is a good candidate for SQL Server replication ( pull replication )
Replication is a complicated topic ( I am just starting to use it myself ). Read up about it in SQL BOL.

P.

kauind wrote:

> Hi
>   I want to develope a program which picks up values Access database and
> insert into Sql 7.0 database. Both this databases r on different machines.
> The database which has Access table is client machine and the machine which
> has SQL 7.0 is the server machine.
>    The thing is that i am developing a intranet project in which the SQL
> 7.0 is installed at the HQ (which is in one city) and there r many branches
> in different cities. The thing is that all this braches will work on the
> Access database and at the end of the day will put all this values in the
> SQL server which is at the HQ
>
> If u r replying to this query, please give  a small example of how do this
> Thanks in advance
>