Mike & Doris Manning
mikedorism at adelphia.net
Tue May 18 06:42:26 CDT 2004
Create a Local DTS package. Set up the first DTS Export task. Then make copies of that task and change what needs to be changed for the other 9 MDBs. Then link the tasks together using On Completion arrows so that they fire one after the other. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Monday, May 17, 2004 5:25 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Local Tables I need to do a multi table select from SQL Server and Insert the resulting data into 10 linked Access MDBs. Never tried this before. Any ideas? Martin _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com