Results 1 to 2 of 2
  1. #1
    aamarb is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2013
    Posts
    1

    Showing multiple row data on a single access form using two excel spreadsheets

    I have an Excel workbook with two sheets. The first sheet contains a list of applications per user. The second sheet contains machine details. I need to create an access form showing the data from both sheets. The issue I have is that users can have multiple applications and/or machines.



    The screenshot below is what i have got so far, but I need all the applications on one record/form per user/machine.
    The blank fields in the table require filling in. So in theory it's like a questionnaire

    Click image for larger version. 

Name:	sample.JPG 
Views:	8 
Size:	51.8 KB 
ID:	14449

    I have attached a sample workbook.

    Or if this is not possible perhaps it can be done via a report
    Attached Files Attached Files

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Here's your file back with an example database included.

    Make sure the database and the excel file are in the same folder before you click the re-link button

    sample workbook.zip

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

Similar Threads

  1. Replies: 22
    Last Post: 12-29-2015, 10:41 PM
  2. Replies: 1
    Last Post: 07-31-2013, 06:39 PM
  3. Exporting data into MULTIPLE Spreadsheets
    By Gagnon 30 in forum Access
    Replies: 1
    Last Post: 02-08-2012, 03:33 PM
  4. Replies: 6
    Last Post: 08-16-2011, 12:54 PM
  5. Access to Excel transferring multiple rows to single row
    By peter_lawton in forum Import/Export Data
    Replies: 10
    Last Post: 09-23-2009, 10:16 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
  •  
Other Forums: Microsoft Office Forums