Appending Data From outside database

[Ryan]

Can someone please help me out? I need to know how to
reference a table in an outside database to import data
from.

For example:

INSERT INTO tblActuals1
SELECT *
FROM tblActuals1 IN \\Server\pathname
WHERE field1 > 5;

I know this is not the correct syntax but if someone could
please lead me in the right direction I would really
appreciate it.

Thanks,
Ryan

 

[JohnFol]

Have a look at the online help. Just found this example

SELECT CustomerID
FROM Customers
IN OtherDB.mdb
WHERE CustomerID Like "A*";