What do you think?
Rate this book
Mastering Excel: MS Query
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.
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
3 people are currently reading
8 people want to read
About the author
Mark Moore
194Ìýbooks3ÌýfollowersLibrarian 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.
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
August 29, 2020
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.
Displaying 1 of 1 review
Can't find what you're looking for?
Get help and learn more about the design.