Data exported out of Access can be dynamically loaded into an HTML table if it’s first converted to the JSON data format. The first step in the process is exporting the data and preparing the HTML document so that it’s ready to receive the records.
- [Instructor] At this point in the course,…we've explored exporting out our data to HTML files…and exporting our data out to plain text data files.…In this chapter, we're going to merge both of those topics…together and use a JSON formatted data file…to automatically populate a table in an HTML file.…This gives us the best of both worlds.…We can create our HTML page ahead of time…and include all the graphics…and other elements that we want,…then we can export just the data from Access…and update it easily whenever we need to.…Let's start the process by taking a look…at the data that I want to export…and share on a regular basis.…
Inside of the KinetEco database,…I have a query set up called Q1_2017.…This is a summary of our quarter one sales data.…We can see that it's organized…by region and division within the company.…I have a call in that counts up the number of orders…that occurred within each division…and the total sales from each division for the quarter.…If I take a look at the query in design view,…you can see that we're pulling data…
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