Hi, everyone
I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code.
If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it?
Thank you.
Discussion posts and replies are publicly visible
Hi motoyay3833 Can you please elaborate your use case.
Hi, harshavardhanv
My MS Access has data table below in it's DB.
■Table1ID | Name | e-mai---|-------|--------1 | name1 | e-mai1---|-------|--------2 | name2 | e-mai2
I created CDT below in Appain.
■CDT1ID | Name | e-mai---|-------|--------1 | name1 | e-mai1---|-------|--------2 | name2 | e-mai2
I would like to import Table1 into CDT1.But, I cant't find plug-in, activities, or action which develops this.
Therefore, I am trying to create RPA Robot that imports Table1 into CDT1 in custom java code.
I think the easiest way, is to create a web API in Appian that you can send the data to.