| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an ADO connection to current sheet
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create an ADO connection to current sheet
Previously posted by Jamie Collins:
http://groups.google.com/groups?hl=e...ing.google.com the URL should all be on one line. -- Regards, Tom Ogilvy "quartz" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 crashes after viewing property sheet in Data Connection | New Users to Excel | |||
| How do I create a connection between cells on different worksheets | Excel Discussion (Misc queries) | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| How do I save an OLAP connection to distribute with an Excel sheet | Excel Discussion (Misc queries) | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
