transfer data

[Ann]

I have to set up a routine like once a day to transfer
data from our web server SQL server database to our
internal Access database.

At the very beginning, the tables in SQL server are the
duplicates of those in Access databases.Then new records
will be added or old records will be updated every day in
SQL server by through some web applications.

I need to import those new records and updated records to
our Access database every 12 or 24 hours. About 5 tables.
What is the best way to realize this?

Thanks for any suggestions.

 

[Sandi]

Ann,

Is there a reason that you don't just "Link" the SQL
tables into your Access database?

Sandi