How to insert Uipath into a linked table in Access?

How to insert Uipath into a linked table in Access?
NOTE: It is not a local table.

Make sure you have the uipath database activities package downloaded. Then you can either use the Insert activity, or use the Execute NonQuery activity and build your own SQL statement

Not worked :neutral_face:




Can you verify that your connection is working properly? That error usually happens when trying to connect to the access database

You should see if a simple “select * from table1” is working. If that works, then try again without the use of paramaters, just hardcode everything. If it works when hardcoding, then add in 1 parameter at a time until you isolate and fix the issue

2 Likes

Great advice Dave.

CAE, I would also take care to verify that the format of your date (and other inputs) in the insert statement is not causing issues.