One of the most common plain-text data file formats is a simple .csv file. CSV stands for comma-separated values, and it’s a specific kind of text file that uses commas to delimit or define the transition from one column to the next.
- [Speaker] One of the most common plain text…data file formats is a simple CSV file.…CSV stands for Comma Separated Values,…and it's a specific kind of text file…that uses commas to delimit, or define,…the transition from one column of data to the next.…There isn't an option for CSV files…specifically in the Export options,…but you can create them using the Text File button.…Let's go ahead and export our Customers table to a CSV…by selecting it in the Navigation Pane,…then going up to the External Data tab…and choosing the Text File option.…
We'll browse out to our file folder,…and we'll save this inside of the Exercise Files, Chapter 2,…and then the 02_03_Delimited folder.…We'll just call it Customers.txt.…Let's go ahead and press the Save button.…In order to get to the delimited options,…we need to make sure that the export data…with formatting and layout option is turned off.…So I'll make sure that it's not checked.…Go ahead and press the OK button.…Here's where we determine what kind…of text file we're going to create.…
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