Pull info out of another database
How do I change this statement to pull information from a different database in my C:/FUNDS.mdb (table is named tblfunds) all the feilds are right (Test.Description, etc.)
VB Code:
SELECT Test.Description, Test.ADSN, Test.[BPAC/PCN], Test.[DOV (Voucher)], Test.ESP, Test.FC, Test.[FY (1 Char)], Test.[Julian Post Date], Test.OAC, Test.OBAN, Test.[Post Date], Test.RCCC, Test.[Trvl Order], Test.[Trvl SSAN]
FROM ;
Re: Pull info out of another database
I don't understand the question. If the table is in c:\funds and you have it opened, and that tables match the select string, then all your From clause needs is the table name.