Operations with Excel data via OLEDB DB Connection using Invoke Code

News Tutorials
1

Hi Guys,

Find the other way to connect to the excel database using oledb connections
find the below Crude Operation implemented:-
1.Select
2.Update

Sql_connection with olebd.zip (9.8 KB)

Regards
Sanjay Shankhla

1 Like
2

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)

Regards,
Jakub Brzezinski