Microsoft Excel - Obtaining Information from Excel Using ODBC

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
Automate Bots are the result of our experience training and implementing Automation initiatives for our customers. All the configurations are maintained by Fortra Professional Services. If you need our help to configure a bot, please complete the form here.