Using ADO to transfer data?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I am trying to query some data from a SQL Server 2000 database, then change the connection and batch update that data into another (but identical in schema) SQL Server 2000 database (some records are different, some new), but nothing happens. I'm sure it's related to the fact that no data has changed in the ADO recordset means it doesn't think a BatchUpdate is worth it. Is there a way to make it go back to the database anyway? Thanks, Simon