Can any one help me connection strings for excel. what needs to be provided in the connection string for excel. I have scenario where i need to query the excel.
I had huge data with multiple columns, i need to use filters for multiple columns and base on each filter i need to set a value for the filtered results.
Thanks for the help in advance.