Access provides a number of ways to export data out of a database. HTML tables provide an easy way to create publishable files that can be uploaded to a website to share with others.
- [Instructor] Access provides a number of ways…to export our data out of the database.…You can find them all underneath the External Data tab…in a section here called Export.…The buttons on the left side of the screen…might look similar…and in some cases they have exactly the same names,…so don't let that trip you up.…They're in the section called Import & Link,…which is not what we're looking to do here.…All of these Export options on the right…operate on the currently selected object…over in the navigation pane on the left side of the screen.…Some objects will have fewer options available,…so you'll see some of these buttons up here at the top…become disabled depending on what type of object…that you currently have selected.…
We'll take a look at most…of these options later in the course,…but for now the one I want to look at is the HTML Export,…which can be found underneath the More button…down towards the bottom.…So let's take a look at exporting the results of a query…into the HTML format.…First, the query I want to look at…
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