Results 1 to 6 of 6
  1. 11-15-2016, 06:30 AM #1
    kitt526
    kitt526 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    3

    Excel In Form


    Is there a way to interact with an excel worksheet inside an Access Form?
    Reply With Quote Reply With Quote
  2. 11-15-2016, 08:20 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Sorta,. You can attach the excel file as a table, then run queries on it.
    Reply With Quote Reply With Quote
  3. 11-15-2016, 08:31 AM #3
    kitt526
    kitt526 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    3
    Can you interact with it? like putting new values into it from a form?
    Reply With Quote Reply With Quote
  4. 11-15-2016, 09:59 AM #4
    Homegrownandy
    Homegrownandy is offline VIP
    Windows 8 Access 2013
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Doing this in excel with data from access seems like a better idea to me. Could be wrong though.
    Reply With Quote Reply With Quote
  5. 11-15-2016, 10:26 AM #5
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    No, access won't allow you to edit excel.
    Reply With Quote Reply With Quote
  6. 11-15-2016, 10:30 AM #6
    kitt526
    kitt526 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    3
    bummer alright thanks for letting me know.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Convert Excel form to an Access form
    By Milade8080 in forum Forms
    Replies: 3
    Last Post: 11-11-2016, 04:58 PM
  2. Display an ExCel Chart on MS Access form using data from Query to create the Excel chart
    By JrMontgom in forum Programming
    Replies: 2
    Last Post: 04-06-2015, 12:08 PM
  3. Module to open a form and pass the values given to the form to ranges in excel
    By craig1988 in forum Modules
    Replies: 6
    Last Post: 10-17-2014, 09:38 AM
  4. How to update an Excel spreadsheet that link to a form while users having the form opened.
    By lylyming977 in forum Access
    Replies: 9
    Last Post: 09-18-2014, 10:16 AM
  5. Export Form And Subform Data To Excel Form Same Worksheet
    By tomtheappraiser in forum Import/Export Data
    Replies: 6
    Last Post: 08-12-2013, 10:39 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums