reference an object in another mdb

  • Thread starter Thread starter LGarcia
  • Start date Start date
L

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
 
LGarcia said:
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??
Click to expand...

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