Susan Harkins
ssharkins at bellsouth.net
Tue Sep 16 09:57:04 CDT 2003
Are you really transferring or just copying the data? INSERT INTO and SELECT INTO are both available -- just use the IN operator to specify the foreign database. Susan H. Dear List: I have a FE/BE app where I need to transfer three of the BE tables to another database. Is there a better way to do this than creating a workspace for the target database, opening the target, opening the source and object tables and transferring the records one by one. The table structure in the source and target databases is the same. The number of records is small. So time is not a consideration. MTIA Rocky Smolin Beach Access Software ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030916/0b4d8c12/attachment-0001.html>