Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Preview/Edit Database table with custom dialog

ADMIN

This Process shows a preview of a selected database table through a custom dialog.

The user can also modify a table's value.


*Note: The table can be also an Excel worksheet (the "$" sign should be used at the end of the worksheet's name).


waj

Peter,

This would be a great tool for me, however, I can't make it work.

Could you please provide an excel file which runs along with this job or, make the job run for Excel ?

Thanks

A. R.

ADMIN

Hello Alan,


Please note that the default connection string that is generated for the excel connection requires the Microsoft OLE DB.12.0 provider which is included in the following download setup:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

However note that you can create and use any other valid connection string.

The action 'Open SQL Connection' has a build-in tool to create a connection string, which can be used in the custom dialog.

image


Also note that you must set the correct name of a column to be treated as a primary key in order for the Process to work.

Login or Signup to post a comment