Results 1 to 3 of 3
  1. #1
    cfljanet is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    58

    viewing an excel spreadsheet interactively through an access form

    I have a database which exports data to an excel file for viewing summary data. The excel spreadsheet has various tabs.

    All of it works perfectly, but I would like to be able to see the excel file, move through tabs etc from within the db. I don't want to edit/change the ss, just to be able to see the summary data in all the tabs. Is this possible?

    (I used to have access reports that mirrored the ss layout and summary data, but since pivot tables are no longer a feature in access, I have to use the ss instead, and I would like to be able to make it as user-friendly as possible for non tech users.)

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    There is a bound object frame control in Access but it provides a static view. I know of no Access control that will provide what you want but would be interested in knowing if anyone points to one. You can open/manipulate data/close Excel from Access but that's probably not what you want.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    There are in fact at least two ways of doing this.

    The simplest is to create a linked table using each worksheet in the Excel file.
    However linked Excel files are read only & any formulas based on a separate sheet will not work
    So that's of limited use

    A much better method involves the use of an ActiveX web browser control.
    This allows you to view and edit the Excel file and switch tabs.

    Click image for larger version. 

Name:	Excel1.jpg 
Views:	18 
Size:	214.5 KB 
ID:	40265Click image for larger version. 

Name:	Excel2.jpg 
Views:	18 
Size:	220.4 KB 
ID:	40266

    The only real downside is that it can be quite slow to load the first Excel file viewed

    The control also works to view/edit Word/PowerPoint/text files and view PDF files within Access.

    The attached zip files includes a sample app so you can try it out
    If the files open outside Access, run the included .reg file
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 4
    Last Post: 03-19-2019, 08:35 AM
  2. Replies: 1
    Last Post: 03-15-2019, 08:20 AM
  3. Replies: 1
    Last Post: 02-02-2015, 04:08 PM
  4. Format an Excel spreadsheet from Access
    By crowegreg in forum Programming
    Replies: 4
    Last Post: 12-23-2013, 07:12 PM
  5. Replies: 2
    Last Post: 02-19-2010, 08:05 PM

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