Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
obvious destination for an Excel spreadsheet would be as a Microsoft Word table or an Access database. One of the ways to transfer data from a spreadsheet to another application would be to use a delimited text format. If I select the File > Save As here in Microsoft Excel, you'll see that I have an option for, in my Save as type dialog Tab Delimited Text, Comma Delimited Text. This is exactly the process that went I through to create the Quarterly_Sales.csv.
Quarterly_Sales.csv is this file delimited by commas. So I'll use that file to import into other programs in a moment. Let's cancel this dialog box. An obvious and the most intuitive way to move information from Excel to Word would be to select the data that you want to move, copy it, and then in Word Paste. Automatically, again because the tight integration in the Suite, it knows how to create a Word table from the Excel spreadsheet. If I can undo that paste, and this time I'm going to open up the file that we have here in your Student Folders, Chapter 12, and I'll need to look at all files. There we are. This csv file, I'll open that up and you can see that it opens up just like it did in Notepad. Commas are intact, all the data is smashed together. If you select this range, go up to Table and Convert - Text to Table, one of the options that we have here is text separated with commas. So it's already prepared to take delimited text and create a proper Word table. Say OK. And now you can see the table inside of Microsoft Word is almost identical to that in Excel. Using delimited data is one of the most powerful ways to move it into an Access database as well. Access can accept and create delimited files for use within other programs.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70493 Viewers
80 Video lessons · 127627 Viewers
52 Video lessons · 62517 Viewers
59 Video lessons · 48226 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.