| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sample with ADO / SQL
I was wondering if someone could post a simple bit of VBA that would run a
basic "SELECT" query on a database using ADO and put the values in a spreadsheet. This would be a great help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel sample with ADO / SQL
Hi Steve,
See Ole P. Erlandsen at: Import data from Access to Excel (ADO) http://www.erlandsendata.no/english/...badacimportado --- Regards. Norman "steve" wrote in message ... I was wondering if someone could post a simple bit of VBA that would run a basic "SELECT" query on a database using ADO and put the values in a spreadsheet. This would be a great help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel sample with ADO / SQL
hi Steve
See http://www.rondebruin.nl/accessexcel.htm See also this page from Ole P. Erlandsen's http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "steve" wrote in message ... I was wondering if someone could post a simple bit of VBA that would run a basic "SELECT" query on a database using ADO and put the values in a spreadsheet. This would be a great help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAMPLE EXCEL DATA | Excel Worksheet Functions | |||
| Can I random sample from a set until every sample is selected? | Excel Discussion (Misc queries) | |||
| Sample Codes for SQL for Excel VBA | Excel Programming | |||
| is there any sample of an excel dashboard ? | Excel Programming | |||
| How do I create a sample in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
