title: VBA - Create ADODB.Recordset from the contents of a spreadsheet
body: <p>I am working on an Excel application that queries a SQL database. The queries can take a long time to run (20-40 min). If I've miss-coded something it can take a long time to error or reach a break point. I can save the results to a sheet fine, it's when I am working with the record sets that things can blow up. </p>
  
  <p>Is there a way to load the data into a ADODB.Recordset when I'm debugging to skip querying the database (after the first time)?</p>
  
  <p>Would I use something like this?</p>
  
  <p><a href="https://stackoverflow.com/questions/2086234/query-excel-worksheet-in-ms-access-vba-using-adodb-recordset">Query Excel worksheet in MS-Access VBA (using ADODB recordset)</a></p>