+ Reply to Thread
Results 1 to 2 of 2

excel inner join junction table from access

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Perth
    MS-Off Ver
    Excel 2007
    Posts
    2

    excel inner join junction table from access

    I can't find tutorials beyond the basic 'SELECT From' queries for Excel. I have an Access database with 3 tables, Clients, Products and client_product_junction. The junction table has only 2 columns with client_ID and product_ID as foreign keys to the primary keys in Clients and Products. What is the Query syntax to return the Inner Join for Clients.name and Products.name? I am happy to follow links for tutorials rather than just the straight up answer. Thank you.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: excel inner join junction table from access

    can you build the query in access? (e-z in visual qry design)
    then all you do is:
    Set getRst = conn.Execute("qsJoinQry")


    but its like:
    SELECT tClients.ClientID, tClients.FirstN, tClients.LastN, tPhones.PhoneNum
    FROM tClients LEFT JOIN tPhones ON tClients.ClientID = tPhones.ClientID;

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Odbc table join or calculated fields in ms query excel
    By mwali23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2015, 01:01 AM
  2. Use an Excel Macro in Access VBA - Import text file in Access Table
    By joogibabu in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-08-2014, 10:04 AM
  3. Access Query NOT EQUAL Join
    By dash11 in forum Access Tables & Databases
    Replies: 5
    Last Post: 04-19-2013, 10:59 AM
  4. Excel VBA (from Access) SQL JOIN/WHERE problem
    By dweben in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 05:17 PM
  5. Access SQL Full Outer Join Into Different Table
    By davegugg in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2010, 02:18 PM
  6. Help Populating a Link (junction) table
    By simjambra in forum Access Tables & Databases
    Replies: 1
    Last Post: 04-28-2009, 06:31 AM
  7. Excel Return of value from junction of x-y axis of a table
    By Pittsburgh Jack in forum Excel General
    Replies: 6
    Last Post: 03-14-2005, 04:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1