Using SSMS, Access data can be exported, brought into the Azure SQL database in the cloud, and then relinked back into Access to provide a cloud storage solution for your Access tables.
- [Instructor] In order to start storing our Access…data in the cloud…we need to export I our of Access,…import it into our Azure SQL database,…and then come back to Access and link to the version…that's being stored in Azure.…I'll demonstrate the process by taking a look…at our products table here inside of our Access database.…This is the table that I want to upload to the cloud.…We'll start the process by going to external data…and exporting is as a CSV file.…I'll click on the text file button…and then come over and press Browse.…I'm going to store this exported data…in the exercise files folder, chapter four…O four O four link tables…and we'll call it products dot CSV.…
Make sure you change the file extension down here.…I'll press the Save button and then press okay.…We're going to export a delimited file.…I'm going to press next.…It's going to be comma separated…and the text qualifier is going to be the double quote.…Make sure that we're including the field names…on the first row, and press next.…Then finish.…
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