Find Excel Files Connecting to SQL

• PatLap

  Mr or Mrs. 500

  Points: 543

  More actions

  September 14, 2011 at 12:57 pm

  #247649

  Hi,

  I have hundreds of Excel files spreadout over some network folders. Some of them might connect to SQL and some of these to a specific DB that needs to be moved to a new server. Is there a way to scan the Excel files to find which one has a connections to the DB? I don't want to over each one and verify each connection. I'm looking for a way to check every files without having to open them. A script, or something. Anybody ever had to face this problem?

  Thanks for your help.

• SQLALX

  SSC Eights!

  Points: 956

  More actions

  September 16, 2011 at 11:54 am

  #1382702

  Please refer to the following blog.

  How to check SQL connection in Excel

• PatLap

  Mr or Mrs. 500

  Points: 543

  More actions

  September 16, 2011 at 12:10 pm

  #1382707

  Nice! Thank you!