DTS: SQL to Access.mdb, INSERT INTO all_tables_destination SELECT all_tables_source WHERE...
Posted on 2007-11-14
I have a SQL2K db and an A2K.mdb, both have the same schema.
(The mdb tables were the 'source' of creating the SQL tables.)
I need to do an INSERT of all records in all tables of the SQL2K source, INTO all tables in the A2K.mdb, WHERE a column = a passed value.
For the moment, I would prefer to avoid using Access VBA code and linked tables to do this, unless there are no other practical options.
My knowledge of DTS is limited to simple data transfer tasks from one source to another.