Mastering Excel: MS Query

by Mark Moore

In this lesson we focus exclusively on the Data layer of the Excel model. Included in Excel 2007/2010 is a program called MS Query. MS Query allows Excel to connect directly to external databases and return data to Excel. then, this data is used in reports, charts, formulas, etc.

We will learn how to load data into Excel. We will cover importing text files (because some databases do not allow direct connections), setting up the ODBC connection to an Access database, importing data, setting up automatic data refreshes, parameters and importing data from webpages.

Included in the lesson are several files (MS Access and text files) that you can use to follow along with the exercises.

129 pages, Kindle Edition

First published July 5, 2013

About the author

Librarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.

Reviews

[Francesco]

Una lettura molto interessante, purtroppo però l'ultima versione di Office ha radicalmente modiicato l'interfaccia e la modalità con cui operare le MS Query.