Update values in excel considering excel as database

Hi,
Need to consider an excel (.xls) as database and hit update query. Please suggest a solution for same.

Hi @ccma
I think a simple click activities will do it, did you find any problem getting the right selectors for this task?

Hi,

To use excel as database you ll need to connect to excel using oldebd.

Before that you ll need to install 2007 Office System Driver: Data Connectivity Components

After installing the driver use the connection string in connect database activity and connection type System.Data.OleDb.

Connection String:

β€œProvider=Microsoft.ACE.OLEDB.12.0; Data Source=β€β€œβ€+filePath+β€œβ€β€œ;Extended Properties=β€β€œExcel 12.0 Xml;HDR=YES;β€β€œβ€

Please note filePath is the string variable which will contain the path of the excel file.

Here is the xaml:
ExcelQuery.xaml (7.9 KB)

2 Likes