Excel is the premier analysis tool. This is the reason for bringing data from other sources into Excel. Microsoft has added even more sources and ways of importing data for Excel 2016.
After reading and working through this chapter you should be able to
Import delimited text and fixed-width text files
Import data from an Access database
Import data as is from a web page and modify and transform it before importing it
Create connections between a workbook and a data source
Importing Data into Excel
Excel’s Ribbon has two groups of buttons for bringing data into Excel. See Figure 14-1. The first group, Get External ...
