I have a excel file which is password protected. I need to use it as database.What should be the connection string.
Hi @Shashi123,
Can you be elaborate the scenario a bit?
I have a excel file which is password protected. I need to write a connection string so that I can use excel as database. Help me with the connection string.
Can you show me the screenshot where you struggling? Do you want to open a password protected excel file?
Hi @Shashi123,
Install database package from manage package âuipath.database.activitiesâ
- Add Connect activity from database
- Click on configuration connection
- Then choose Connection wizard
- And select âMicrosoft ODBC Data Sourceâ and click ok
- Select Use connection string radio button
- Click on build button
- Choose Machine data source tab
- Then click new button
- And select âMicrosoft Excel Driver(â.xlsâ,â.xlsxââŚ)â then click next button
- Click finish
- Given name for the datasource
- Click select workbook and choose the excel file then click ok
- Choose the name that added recently from the list
- And click ok button
- Now test the connection
1 Like