I already make a form by using access
And i wan to pass data table value in the uipath to above access form
Can i help to achieve this problem
I already make a form by using access
You can loop the datatable using for each row, and inside that place a attach window activity to attach the access window.
Then you can use type into for each row cell value and type the value there.
We able to get selectors for each fields in the access form.
Sample selector:
<wnd app='msaccess.exe' cls='OMain' title='Access - Database1 : Database- C:\Databas*' />
<uia idx='1' name='End Time' role='edit' />
yah if the datatable is passed as a input for each row loop and inside the loop use a expression like this in a type into activity
row(“yourcolumnname”).ToString
or if we know which row and column data we want then we can directly mention the input like this in type into activity
Datatable.Rows(rowindex)(columnindex).ToString
or
Datatable.Rows(rowindex)(“yourcolumnname”).ToString
where both row index and column index starts with 0 for first row or first column
hope this would helpyou
Cheers @Mahesha_Mendis
you can use for each row activities in uipath, inside you can use type into activities to type the data into different backet, but make sure the form can be recognized by uipath.
Can you please give me the example
WriteTotal.xaml (8.9 KB)
You can try with a new attach window activity from your end in a new xaml file.
Which version of UiPath Studio you are using? Mine 2019.10
I use uipath 2019.10
Im try with new xaml but same error occurred
Yes i have already installed
Then something wrong with the studio, just restart and check the same please
Thank you
Really it’s working
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.