SQL Query with Excel

This month's task looks at using the SQL Query action in a unique way. Using the Microsoft JET database provider, AutoMate can access an Excel spreadsheet like a standard database. This makes gathering and collecting data from a spreadsheet more efficient then opening Microsoft Excel and manipulating the spreadsheet manually.

This ZIP file contains two sample tasks and a sample Excel spreadsheet. For best results, place the Excel spreadsheet on the root C:\ drive. Or, if you are feeling savvy, open the sample task in the Task Builder and modify the SQL Query step to point to the Excel spreadsheet of your choice.


Click here to download the task