Follow this article to access Excel QueryTable using C#. It has details to set the IDE, a list of steps, and a sample code for accessing and updating the Excel external data connection using C#....fetch it, and update its properties if required. Steps to Update...connection and display its properties Update the connection settings...