Can any one please provide any solution on the below requirement.
1. Once we export .iqy file from Sharepoint site and if any one update from sharepoint site.
2. I need current live data from .iqy file downloaded from sharepoint site with out refresh using C# code
3. I need that live data from .iqy file(downloaded from sharepoint site) and export to excel with out clicking on refersh button.
Once i downloaded .iqy file from sharepoint what ever data updated in the sharepoint i need that data automatically save into my MS SQL server database using c# code with out click on referesh button in .iqy file.
Currently i am doing manual process in the below steps: 1. Downloaded the copy .iqy file from sharepoint 2. open the excel sheet(.xls) and load that .iqy file in my excel
3. once loaded the data in the excel and clicked on the refresh all option in excel to get live data .
4.Next I am storing this excel data into my SQL server DB.
Pain area every time i am doing manually to click on refresh butto to get live data to excel and how to over come this manual process to automatally that .iqy file live data pull stored in excel /any other data source.
Please help us on this requirement.