How can I access a table from another database without linking

  • Thread starter Thread starter arm
  • Start date Start date
A

arm

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

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

Ramon
Click to expand...

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";
 
Back
Top