Execute SQL queries to Microsoft Access
Access files consist of tables. We can execute SQL queries to those tables, using the "Database" actions.
Verify that any one of the below drivers are installed on your machine. If not, install one of them through the links below.
- 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_AccessFile%; Persist Security Info=False;
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.