create select query with diff. mdb files

You need two Queries. One with Select command for one table, other with select command for the other table. A try to write an example in Delphi, how can this work.

ADOQuery1.SQL.Add(?select * from table1?);
ADOQuery2.SQL.Add(?select * from table2?);
Repeat
Begin;
ADOQuery1.SQL.Clear
ADOQuery1.SQL.Add(?insert into table1(field1,field2) values(?+ADOQuery2.SQL. FieldValues[?fieldA?]+?,?+ ADOQuery2.SQL. FieldValues[?fieldB?]+')');
ADOQuery1.SQL.Execute;
ADOQuery2.Next
End;
Until ADOQuery2.EOF

There are many other possibilities, (for example Visual Foxpro? is the easiest way. ?use table1 append from table2).
I hope help.

Open one of the db's;
In the file menu, select import or link data;
Navigate to the second mdb;
Select the table to import or link;
Now this table is visible in the tables list;
Create a qry like you would with two internal tables.
Good luck!

Open one of the db's;
In the file menu, select import or link data;
Navigate to the second mdb;
Select the table to import or link;
Now this table is visible in the tables list;
Create a qry like you would with two internal tables.
Good luck!

If you have two Access databases A and B.

You are in a query window in database B and need to access a table from database A. Then you need to create links to the required tables from database A. Now, you can use these linked tables in your query.

Hope this is what you needed.

Cheers,
Steve

If you have two Access databases A and B.

You are in a query window in database B and need to access a table from database A. Then you need to create links to the required tables from database A. Now, you can use these linked tables in your query.

Hope this is what you needed.

Cheers,
Steve