Query using tables in different .mdb files

Damaso

Delphi Developer

Sat, 13 Nov 2004 19:01:13 GMT

Query using tables in different .mdb files

How can I make a query using different access files?

select *
from Table1 in 'C:\aaa.mdb', Table2 in 'C:\bbb.mdb'

The above sql statement doesn't work.
Does anyone knows what seems to be the problem?

Thanks

Eric Hil

Delphi Developer

Sat, 13 Nov 2004 21:43:11 GMT

Re:Query using tables in different .mdb files

In Access, you'll need to use a database link a table to an external
database.

Then you'll use "select * from table1 union all select * from
linked_table2".

Eric

Quote

"Damaso" <Dam...@rigor-p.com> wrote in message news:3cf36222_1@dnews...
> Hi

> How can I make a query using different access files?

> select *
> from Table1 in 'C:\aaa.mdb', Table2 in 'C:\bbb.mdb'

> The above sql statement doesn't work.
> Does anyone knows what seems to be the problem?

> Thanks

Other Threads

1. Rename the table in mdb file using SQL statement

2. Repairing Access MDB files (different ways available ?)

3. Inserting Data into Two Different Tables by querying from a single Table

4. Inserting Data into Two Different Tables by querying from a single Table

5. Copy a table from a .MDB to other .MDB

6. Query SQL statement accessing 2 MDB files

7. Querying two Access MDB files

8. Open Different Paradox Table using same Table Component

9. D5 using Access 97 mdb with linked ODBC tables - slow performance

10. Using a Microsoft Access .mdb file