Page 650 - Excel 2013 All-in-One For Dummies
P. 650
632 External Data Query
After you click OK in the Import Data dialog box, Excel imports and parses the text file data starting at the current cell. Figure 2-15 shows the rows
of the imported and parsed text data that appeared in the new worksheet (Sheet2) starting at cell A1.
Figure 2-15:
New worksheet with data after opening the parsed text file.
Querying data from other data sources
Database tables created and maintained with Microsoft Office Access are not, of course, the only external database sources on which you can perform external data queries. To import data from other sources, you click the From Other Sources button on the Get External Data button’s drop-down menu on the Data tab or press Alt+AZXFO to open a drop-down menu with the follow- ing options:
✦ From SQL Server to import data from an SQL server table.
✦ FromAnalysisServicestoimportdatafromanSQLServerAnalysiscube.
✦ From Windows Azure Marketplace to import data from any of the vari- ous marketplace service providers. Note that you must provide the file location (usually a URL address) and your account key before you can import any marketplace data into Excel. (Visit www.windowsazure.com for details on using this service.)
