[AccessD] Trasnfer Table Between Databases

I know that you can do SELECTs from multiple MDBs in a single SELECT
statement. I never tried an append query across MDBs but I think it would
work.

A.
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
  Sent: Tuesday, September 16, 2003 7:55 AM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Trasnfer Table Between Databases


  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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030916/a2b54c4e/attachment-0001.html>