Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Aug 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Passthrough queries (2002/SR3)

    I have an access database connected via ODBC to an Oracle database. I want to extract data from the Oracle database and put it into an access table. The selection query I need is too complex for MS Access (requires several outer joins) so I plan to use a passthrough query and let Oracle sort it out. Can I assume that only the SELECT part of the query will be passed through and the INSERT bit will be treated locally? In other words, will it still populate local tables?

    Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Passthrough queries (2002/SR3)

    Graeme,
    I think your best bet is to create the SELECT query as a pass-through and then create a separate Make Table query that uses that first query in its FROM clause. I do not think you can do it in one query.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Passthrough queries (2002/SR3)

    Have you tried the Access query with several outer joins?

  4. #4
    Star Lounger
    Join Date
    Aug 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Passthrough queries (2002/SR3)

    Thanks Pat. The techo who is doing the job said the query he wanted could not be done. I will talk to him and find out more details.

    Graeme.

  5. #5
    Star Lounger
    Join Date
    Aug 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Passthrough queries (2002/SR3)

    Thanks. I will try this.

    Graeme.

Posting Permissions

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