Hi Guys can you guys please let me know How to upload data from Accss DB to Sql DB. and after that from excel to Access DB.
Hi Buddy @ryava_santhoshi
we have an activity called Execute query to execute a query in access db, and get the output from the query as datatable…again use a execute query to connect to sql db and use insert query activity to insert that datatable to sql db…
Similarly for excel to acces db, use insert query activity to insert datatable read from excel using read range and mention the table name from db in the activity as input
for both the activity we need a package called uipath.database.activity from manage packages in design menu and we need server name, username and password to connect to the db
Hope this would help you buddy
Thank you so much @ Palaniyappan for quick answer. If possible can you please provide sample xamlfile for better understandin. bez I am new to this topic.
Here you go buddy @ryava_santhoshi
db.xaml (8.8 KB)
Thank you so much Palaniyappan for this sample and for quick response.
Is that working buddy
Palaniyappan we are going to work on this from this Thursday or Friday. I am just collecting the info bez i am new to this topic na. I will definitely let you know regarding this. Thank you so much for concern and helping by giving quick response.
No worries buddy