Combine two tables from two databases into one table

[needmoremoney]

Can some help me with a sql statement.

I have two access databases. A and B.

I need some tables in A and B to combine together.

For example I want to pull from Database A a table named Adress and the same table from database B into a temp table call ABAdress that is located in A.

I'm trying this:

Select * Into [\\server9\A].ABaddress
From(
Select * From [\\server9\A].address
UNION ALL
Select * From [\\server9\B].address
)temp


Would this work? Or is there a better way. Thanks much.

 

[PCLewis]

Have you ever tried File | Get External Data | Link Tables?

There ar emany code samples in these forums to show you how to do it programatically, but if your need is simple, then linking to a table on another machine is pretty easy by following the wizard.