Results 1 to 3 of 3

Create a datasheet view in SharePoint

  1. #1
    MacMac is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    4

    Create a datasheet view in SharePoint

    I have a half-dozen tables in SharePoint, published from Access 2016. I want to provide users with an editable view of the tables.
    Here's what one of those queries looks like in Access:
    Click image for larger version. 

Name:	snap.jpg 
Views:	22 
Size:	33.4 KB 
ID:	28507
    One table is called Site, which lists a bunch of sites (locations), with a Site_ID, name, address, city, state, etc etc.
    The other is called Discrepancy, listing a bunch of work cases, each with a Site_ID that is joined to the Site table.
    In Access, the worksheet looks like this:
    Click image for larger version. 

Name:	view.jpg 
Views:	22 
Size:	66.7 KB 
ID:	28508
    (Note: Some columns of proprietary data have been hidden in this screenshot.)

    As SQL, that query is simply:
    SELECT Discovery.Site_ID, Discovery.SiteNumber, Site.SiteName, Site.Region, Site.Address, Site.City, etc etc etc ...


    FROM Discovery INNER JOIN Site ON Discovery.Site_ID = Site.Site_ID;


    When I published the database to SharePoint, I thought that this query/view would be published. But no. Only the data tables were published.

    So now I need to create that datasheet view in SharePoint that will allow users to edit the (joined) table data, much as they would in Access.
    I was able to create a datasheet view of the Discovery table in SharePoint. But I can't find a way to join that to the Site table.

    Can anyone point me in the right direction?

  2. #2
    marketing118 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2019
    Location
    Canada
    Posts
    1
    • Yes! good information. Click Create View then Datasheet view and view name & configure columns.

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,554
    @marketing118, welcome to the forum - but think you are a bit late, question was posted over two years ago. But your response may help others

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

Similar Threads

  1. Replies: 3
    Last Post: 01-15-2015, 12:23 PM
  2. Replies: 2
    Last Post: 01-28-2014, 10:13 PM
  3. Replies: 3
    Last Post: 08-18-2013, 09:14 PM
  4. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  5. Replies: 16
    Last Post: 09-12-2012, 08:39 AM

Posting Permissions

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