How can I access a table from another database without linking

[arm]

Could anyone please help me how can I access a table from another database
without linking? Thanks.

Ramon

 

[pietlinden]

Could anyone please help me how can I access a table from another database
without linking?  Thanks.

Ramon

straight out of ADH

For Access databases, you use the following syntax:

FROM tablelist IN "path-and-database"

The following SQL statement select fields from the tblOrder and
tblCustomer tables located in another Access database:

SELECT OrderId, ORderDate, LastName AS Customer
FROM tblOrder INNER JOIN tblCustomer
ON tblOrder.CustomerID = tblCustomer.CustomerID
IN " d:\a2kdh\VolumeI-2370\ch04\ch04.mdb";