How to import excel sheets as tables into a database?


#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


#3

This should help. Thank you @acaciomelo


#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)


#6

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