title: Reading a dataframe from an odc file created through excel using pandas
body: <p>My company has done some work through SQL and allows us to get access to some dataframe through requesting SQL source from Excel. 
  So I have requested the spreadsheet from data>other source> and created this <code>.odc</code> file (a sort of a data connection) which allows me to read to that particular dataframe
  So I would like to read the dataframe using pandas but not sure how to do it</p>
  
  <p>I thought about using the sqlalchemy import to create engine
  but the thing is, the IT colleague is the one that has done all the SQL work, I just need to read the file so I'm not sure if this is the solution.</p>
  
  <p>I thought about using the following:</p>
  
  <pre><code>from sqlalchemy import create_engine
  engine = create_engine('postgresql://user@localhost:5432/mydb')
  </code></pre>
  
  <p>Is there a way to read directly to the <code>.odc</code> file and get the dataframe I wanted from the connection file? </p>
  
  <p>any suggestions are welcome</p>