anand m

anand m

  • 1.4k
  • 346
  • 35.6k

how to retrieve live data from query.iqy to MS SQL without refresh

Jan 8 2023 4:09 PM

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  with out refresh using C# code

3. I need that live data from .iqy file 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.

Please help us on this requirement.


Answers (2)