reference an object in another mdb

[LGarcia]

Hi,
In my database I need to write some code that will export a table that
exists in another database to a text file. Can you reference a table in a
different database without it being linked to the one you are using? If so,
how??
Thanks!
LGarcia

 

[Tony Toews]

In my database I need to write some code that will export a table that
exists in another database to a text file. Can you reference a table in a
different database without it being linked to the one you are using? If so,
how??

Write a query using the IN clause

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

or

SELECT CustomerID
FROM Customer
IN "C:\DBASE\DATA\SALES.MDB"
WHERE CustomerID Like "A*";

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm