Results 1 to 2 of 2

Thread: Pull info out of another database

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Question 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:
    1. 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]
    2. FROM ;

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width