Copying a table between two external databases

  • Thread starter Thread starter Alp
  • Start date Start date
A

Alp

Hi Experts,

Back to "school" again. :-) Somehow I always end up getting all sorts of
unrelated finds when I do a search so here's the question:

Is there a proper way to copy say 2 tables (with the contents) from one
external database to another? I do not want to use a 2 fold action as
TransferDatabase and CopyObject, that is if I can do without them.

Thanks in advance and have a great day.

Alp
 
Alp said:
Hi Experts,

Back to "school" again. :-) Somehow I always end up getting all sorts of
unrelated finds when I do a search so here's the question:

Is there a proper way to copy say 2 tables (with the contents) from one
external database to another? I do not want to use a 2 fold action as
TransferDatabase and CopyObject, that is if I can do without them.
Click to expand...

The other day I read you can have an IN clause within the FROM, where
you can indicate which database the table(s) is/are in.
 
Alp said:
Back to "school" again. :-) Somehow I always end up getting all sorts of
unrelated finds when I do a search so here's the question:

Is there a proper way to copy say 2 tables (with the contents) from one
external database to another? I do not want to use a 2 fold action as
TransferDatabase and CopyObject, that is if I can do without them.
Click to expand...


You can use a Make Table (or Append) query. Just specify
the IN option in both the INTO and FROM clauses.

Some external data sources may not allow this, but it
definitely works fine for Jet (Access) databases.
 
Hi and thanks to you all.

Since everyone is pointing to the same direction, I'll have to get good on
making it work.
I will try the query.

Thanks again,

Alp
 
Back
Top