How to upload data from Accss DB to Sql DB

Help
1

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.

1 Like
2

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
Cheers

2 Likes
3

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.

1 Like
4

@ryava_santhoshi
Here you go buddy @ryava_santhoshi

  1. image
    image905×488 21.8 KB

    image
    image858×285 11.8 KB

    image
    image382×516 7.34 KB

  2. xaml
    db.xaml (8.8 KB)

Cheers

1 Like
5

Thank you so much Palaniyappan for this sample and for quick response.

2 Likes
6

Is that working buddy
Cheers

1 Like
7

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.

1 Like
8

No worries buddy

Keep going

Cheers