• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

Using a Pivot Table to Report Information to the Web

I would like to take a pivot table, make some changes to the way it appears (report?) and display it on a web page.  Secondly, I would like it automatically updated, I think this happens automatically.  I'm not sure if this is possible for a beginner.  I've got the Pivot table near where I want it, however, am not sure if what I want is possible.
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You cannot display Access objects on the web. You could build your query, then build a report of it, then "print" it to a PDF file and display that on your web (after you upload it, of course), but this wouldn't automatically update data as users enter it.

You could use a web-based language (ASP.NET, PHP, Perl, etc) to interact with a charting component to display something like this from your Access database. You'd have to put your db on the web server, of course, since you cannot remotely connect to an Access database, and that would likely be troublesome, since your local users wouldn't be able to enter data to the web-based db.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now