Create an ADO connection to current sheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO - Access to Excel 5
return ADO record set from Add-In? 1
Problems with ADO connection to same workbook? 1
Get single ADO Recordset from multiple Access Databases 2
Using ADO to get data from Worksheet in Same Workbook 4
Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset 4
Selecting record to edit using ADO 6
Populating a multi column listbox with ADO Recordset 2

Top