This bot retrieves rows from Excel using ODBC.  You’ll see how to use a SQL Query to obtain the information of all rows in an Excel file. Using SQL Query, you can manage the information from Excel documents and insert the data in your own database.

Prerequisites: Microsoft Ole DB Provider for ODBC Drivers (usually comes with Office installation)

You can use this bot to:

• Obtain the data of an Excel document with a simple SQL Query
• Insert the Excel rows in a table of your database (if you already know SQL language)

 This task is compatible with:

• Automate Ultimate 11.2 and greater
• Automate Plus 11.2 and greater
• Automate Desktop 11.2 and greater