Emulating TBatchMove with ADO components
Posted on 2000-05-03
I'm looking for a way to emulate BDE's TBatchMove ability to copy records between two different databases (eg: Oracle to Access) using ADO components. The only method I've seen so far is:
1. Use "Create table" SQL to manually create the destination table structure
(TBatchMove does this automatically)
2. Iterate thru a TADOQuery recordset and [Append..Edit..Post] each record to a TADOTable
Would anyone have an example of something like "Select ... into DestTblName" that can operate on an entire set of result records into an implied table structure? I can do
this for source and destination tables in the same database, but not between databases.
Thanks for any guidance!