Appending Data From outside database

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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
 
Have a look at the online help. Just found this example

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