title: Oracle SQL to Excel - Integration
body: <p>I have MANY (60+) complex queries using different tables and views from an oracle database which I am trying to report in excel. </p>
  
  <p>What would be the most efficient approach in doing so? The query results will also need to vlookup with some pre-assigned values in excel in order to place the outputs accordingly. And the excel file will need to have a VBA macro setup to refresh and update the file when needed. </p>
  
  <p>The applicable method in excel using microsoft query is not efficient. What are the other options? I have tried researching but could not find anything which is very automated and smooth.</p>