How to connect Excel with Database

Hi @Santhosh_Hyd,

The .xaml Excel DB Connection.xaml (11.9 KB) can be added to your UiPath library and then it will make easy for you to connect excel to database whenever needed as I created something generic which relies in dynamic variable (excel file name, excel sheet name). It also gives you two SQL statement (select, update) to facilitate interacting with the file.

Additionally, you can refer to this link to better understand the syntax needed for querying and updating excel files with SQL.

2 Likes