One of the standard methods of sharing data is through the use of XML files. XML stands for extensible markup language. Like HTML, XML uses tags that surround values in order to give them meaning.
- [Instructor] Exporting your data to plain text-based files…makes them highly portable and useful…in a wide variety of circumstances.…Unlike proprietary formats such as Excel files or PDF files,…plain text files can be opened by any computer out there…and their contents are often both human readable…and machine readable.…That means that the values are in regular text,…and not converted into binary values,…and their simple structures allow computers to easily…parse the information and pull out values on their own.…One of the standard methods of sharing data…is through the use of XML files.…
XML stands for Extensible Markup Language.…Like HTML, XML uses tags that surround values…in order to give them meaning.…Unlike HTML, though, the tags that XML files use…can be defined by the author of the data.…In the case of XML files exported from Access,…the tags will be whatever the column and object names are…that you've used in your own databases.…Let's go ahead and export the Customers table…into an XML file to take a look.…
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