Execute SQL queries to Microsoft Excel

Excel files consists of one or more Worksheets. A Worksheet can be treated as a SQL Table.

Requirements

Verify that any one of the below drivers are installed on your machine. If not, install one of them through the links below.

Process Designer

  • In the "Set Variable" action, set the file's full path accordingly.

  • In the "Open SQL Connection" action, the following "connection string" can be used:

    *Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%FullPath_ExcelFile%;Extended Properties="Excel 12.0 Xml;HDR=YES";

  • In the "Execute SQL Statement" action, queries can be performed, such as the "SELECT", the "INSERT INTO" and the "UPDATE".

  • Close the SQL Connection after the statements have been executed, via the "Close SQL Connection" action.

Additional resources