Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

connection sring

Hi,


I am exploring WinAutomate and would like to create a simple SQL statement to an excel file. In order to do so, i need to add the "Connection String" in the "Execute SQL Statement" action. Having O356 running (below screenshot of my exact version) I wasnt able to find the right connection string. I have downloaded the most recent ODBC driver already


Im getting the ERROR [IM002] and my connection string is "Driver={Microsoft Excel Driver (*.xls, *.xlsx)};DBQ=%Source%;" DBQ has the variable with the excel file location on my local device


image




Best Answer

Not sure it will help but I'm using the following connection string to Excel 16.0.4966.1000 (64-bit):


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

Login or Signup to post a comment