Create an ADO connection to current sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create an ADO connection to the current sheet, run a SQL query and
retrieve the results in a recordset.

I have used ADO before, but I don't know how to connect to the current
sheet. It seems like there should be a quick and easy way to do this.

Does anyone have concise and effiicient code that does this? TIA.
 
Back
Top