SQL Query an Access Database

Demonstrates the use of Automate's "SQL Query" action

This task will demonstrates the use of Automate's "SQL Query" action. The attached database has three different tables to select data from. Automate will retrieve data from the "ProductType" and "ProductLineDescription" columns of the "ProductLine" table and display the results in a message box (separated with a pipe "|"). 

Note: Make sure you either copy the database file to the root of the C:\ drive or change the path in the "SQL Query" action to the database location.

Task Category: