Operations with Excel data via OLEDB DB Connection using Invoke Code

Hi Guys,

Find the other way to connect to the excel database using oledb connections
find the below Crude Operation implemented:-

Sql_connection with olebd.zip (9.8 KB)

Sanjay Shankhla

1 Like

Thanks Sanjay,
This is what I was looking for - clear and simple!
Updating excel with OLEDB is also useful when it goes to multi user file access (file gets updates despite users have file already opened or not).

I’ve reshaped your code to create dynamic component for one-conditional queries. Maybe someone find this useful - feel free to use it (and improve it) > ExcelOledbUpdateCode.xaml (8.7 KB)

Jakub Brzezinski