Queries 01)

01) Execute Highlighted SQL Statement

This is the core function that spawned the development of The Data Wand.

Did you know that you can extract data from any ODBC or OLE DB data source? In more simple terms let’s just say that data is more available than you might think.

This video will first demonstrate how to execute a SQL statement against an Access Table, then against an Open Excel Workbook, and then against a MySQL data base.

The main thing you need as a user is the Driver, the Connection String information, and rights to read that particular data base.

If gaining access to your data is important and you almost always bring it into an Excel environment, then this is your number one tool!

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc