Learn how to import data from text files and databases directly into Excel.
MS Query is the precursor to Power Query (aka Get & Transform). Learn how to get data directly into Excel from:
- Text files
- Databases
- Webpages
This old dog can still do some things that Power Query can’t. You will learn how to set up ODBC connections, parameters and automatic refreshes.
What can MS query do that Power Query can’t?
- Use SQL in a user-friendly built in interface
- Set up parameters. When a cell changes, the query executes automatically
This is a worthwhile skill to add to your Excel toolbox.