At 03:46 PM 10/16/2001 -0500, Mike Grover wrote:

>Is it possible to copy data from one table to another where the tables
>have the same structure, but are in 2 different database's?

Possible, sure. Depends on how you go about it. The easiest way
(in my opinion - whose did you expect?) is QLI

QLI> ready <db1>.gdb as source
QLI> ready <db2>.gdb as target
QLI> target.<table> = source.<table>

Matching is done on column names.

To define a table in one database that reflects the structure of
a table in another database ...

QLI> ready <db1>.gdb as source
QLI> ready <db2>.gdb as target
QLI> define relation target.<table> based on source.<table>


Regards,

Ann
www.ibphoenix.com
We have answers. Mine are antiquarian.