When exporting data from Access, users have the option to save the export steps and link them to an Outlook task. Doing so can streamline future exports and ensure that they occur on a regular schedule.
- [Instructor] You might have noticed that every time…we export data out of our Access databases,…that Access prompts us to save the export steps.…Even though the export process is fairly straight forward,…saving the steps can actually save time…in an unexpected way.…If you use Outlook for your e-mail and calendar,…a saved export will actually give you the opportunity…to create a scheduled task in Outlook that you can use…to remind yourself to perform a routine export…and actually complete the task right there…inside of Outlook.…To see how this works, we first need to export a file.…Now instead of working with a query,…I want to export a table here called Products.…
So go ahead and make sure it's selected…in the navigation pane.…Then, we'll switch over to the external data tab.…This technique will work with any…of the file types available here,…but let's just continue working…with the HTML type that you can find underneath…the More button and then HTML Document.…First we'll click on the Browse button.…That'll allow us to go out to our file folder…
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