Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  regulary dumping data from an access db to a SQL

Author  Topic  plocke Starting Member 15 Posts Posted - 2000-10-17 : 18:15:22 Dear esteemed friends and other great minds, Can you help me route a path thru this scenerio. Topography: I have two databases existing in two different hosting locations. One is an Access Database(don't laugh - I inherited it) the Other is a SQL2k database. Mission: I need the content from two tables in the access database to regulary dump/ or update the contents of a the SQL database which is otherwise a read-only version of the Access one used for searching etc. via the web. It must be automatic as the users on both ends are inept and my role shall not extend beyond setting up this configuration. Any ideas on how best to do this? *bows* *presents gifts of incense, spices and oils* Thank You.