How to import excel sheets as tables into a database?

Help
1

Hello all,

My question is, How to import excel workbooks into databases using UIPath?

Thank you
Amitha

2

Hi @Amitha,

I’m not sure if I understood your question, but there’s an activity that basically creates a datatable from the excel, which is the Read Range activity and after that you could follow the example below:

or

2 Likes
3

This should help. Thank you @acaciomelo

1 Like
4

If the database is an MS Access one, you could automate the Import feature from Access. Otherwise you could also try to convert the save the workbooks as csv and do a bulk import in the database (most of them support this)

2 Likes
6

Thank you @theo500. The database being used is MySql.

1 Like