Copying a table between two external databases

[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

 

[Bas Cost Budde]

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.

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.

 

[Guest]

hi,
Sounds like you are taking about remote queries.
check out Garry Robinson's site
http://www.vb123.com/toolshed/02_accvb/remotequeries.htm
good luck

 

[Marshall Barton]

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.

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.

 

[Alp]

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