Loading JSON data into an HTML table requires a web server for security purposes. In order to provide a testing environment, a local web server such as WAMP can be installed.
- [Teacher] In this chapter I'm going to show you…how to build a dynamic webpage that automatically…populates an HTML table from Json data files.…This is a great way to export your data…out of Access and make it publicly viewable.…To get this to work though, we need to do…a little bit of housekeeping first.…The issue is that most web browsers typically…won't load data files that are stored…on a local computer such as on your C drive.…This is for security purposes.…After all you probably wouldn't want any website…to just be able to dig into your own computer's files.…
So for this chapter we need to be able…to upload our files to a web server.…If you already have access to a server…that you can put files on and retrieve…through HTTP requests, then great you're all set.…For everyone else though we need to install…a web server on our local computer.…Now the most popular web server on Windows…is called Wamp which stands for Windows Apache…My SQL and PHP.…It's a collection of programs that all work together…to simulate a server environment.…
In this course, Adam Wilbert shows you how, by exploring options for getting your data out of Microsoft Access, making it easier to share with others. He covers Access data export options, and demonstrates how to modify exported files with a text editor. He also explains how to link Access to an Azure SQL database to provide a cloud storage solution for your Access tables.
- Why not use web apps?
- Exporting data to HTML
- Formatting HTML with table CSS
- Working with data exports
- Converting data to JSON
- Building a webpage to parse exports
- Linking to an Azure SQL database
- Linking Access to Azure tables
- Interacting with data on the web