[AccessD] Trasnfer Table Between Databases

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Sep 16 10:05:30 CDT 2003


I think I'll try TransferDatabase first.  Found a link http://www.applecore99.com/gen/gen055.asp which lays it out pretty plain.  That way I don't have to open the target database or make links.

Thanks and regards,

Rocky

  ----- Original Message ----- 
  From: Susan Harkins 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, September 16, 2003 7:57 AM
  Subject: Re: [AccessD] Trasnfer Table Between Databases


  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



------------------------------------------------------------------------------


  _______________________________________________
  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/a623509b/attachment-0001.html>


More information about the AccessD mailing list