title: Parsing Microsoft ODC file to connect to SQL Server database
body: <p>I have an Excel workbook that I inherited and it refreshes data from an external data source. The connection string is:</p>
  
  <pre><code>DRIVER=SQL Server;SERVER=XXXXXX;UID=XXXXXX;Trusted_Connection=Yes;APP=Microsoft Office 2003;WSID=XXXXXX;DATABASE=XXXXXXXX;Network=XXXXXX
  </code></pre>
  
  <p>Can I use this information or the ODC file to connect to the database to query the table within?</p>
  
  <p>Thanks.</p>