How to import excel sheets as tables into a database?


Hello all,

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

Thank you


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:



This should help. Thank you @acaciomelo


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)


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