Updating Records from 1 server to another

[Hemish]

Hi,

I need some help, I’m trying to update 1 database which is in SQL on one server with data from another database which is on another server There are around 8000 records. It is taking for ever updating the data via MS Access Append Query and Update query. Do you know if there is any other faster way in code, which can be updated? Maybe in a loop doing 100 records at a time or any other suggestions.

Reason I need a faster way is the data on the SQL database is needs to be updated is linked to a website with data in , while the data is being updated the website crashes.

I would really appreciate your help.

Thanks

 

[namliam]

update the data within the sql server. ie. upload your new/updated records and run an append/update in SQL Server. This should be much faster...