Results 1 to 4 of 4
  1. #1
    mchadwick is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    71

    Export Data from Related table as well primary table

    I have a table with a 1 to many relationship
    table one- Active Users 1 user from this table
    table two- User Assists Many records from this table.

    I want to export the little plus signs (from the relationship) into excel. I would like to use it the same way.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    vFile = "C:\mypath\files\ExportFile.xlsx"
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsActiveUsers", vFile, True,"ActiveUsers"
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsUserAssists", vFile, True, "UserAssists"

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    or create a query to export, joining the two tables.

  4. #4
    mchadwick is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    71
    I just realized my profile was showing an older version of Windows and Access. I'm now on Windows 10 with Access 2016.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 10-11-2017, 03:13 PM
  2. Replies: 3
    Last Post: 04-09-2014, 12:48 PM
  3. Go To Record with related table Primary Key
    By jamiebull21 in forum Forms
    Replies: 3
    Last Post: 02-17-2012, 09:36 AM
  4. Replies: 11
    Last Post: 11-13-2011, 06:57 PM
  5. Replies: 2
    Last Post: 10-19-2011, 06:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums