Export table1 from db1 to db2 from db3

[Guest]

How can I export a table in one external databse to a second external
database, but do it from a 3rd "current databse"?

Thanks you

Ross

 

[Jeff Boyce]

Ross

It might help to know what business need you are trying to solve by making a
duplicate copy of a table...

Have you considered linking to tables in your DB1 and DB2 from your DB3, and
using update queries (or delete, then append queries) to "load" a copy?

 

[Guest]

I am archiving critical tables into a secure history database as part of the
financial "closing the books" process. All of the tables are in the current
database and I have no trouble using "tranferdatabase" for those tables.
However, one table is a large, table linked from and external database.

I could import this table into the current database and then export to the
history database but that would bloat my current database and require
compacting.

I was hoping that there was a direct way to do this.

Hope this clerifies what I am trying to do.

 

[Jeff Boyce]

Ross

What about my suggestion of using linked tables (rather than importing)?

Is there a business need to physically remove rows from one place and put
them somewhere else?

Would it suffice to have a row "marked" as "Closed", but left in the same
table?

If you need a copy of the data, identifying which rows are "Closed", you
could use a simple backup copy of the entire database. This has the added
benefit of including all the other contexts at the time of "closing the
books."