| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using SQL (with a Group by function) inside EXCEL VBA
Hi,
I have some data on a worksheet. I would like to use this data as input into a SQL query (Select .... from Sheet1....group by....) and load the query output on a different worksheet. How can I set up a Excel VBA macro with a SQL that will allow me to do this? -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation Context available inside an Excel VBA function? | Excel Programming | |||
| Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
| Selectig rows inside a group | Excel Programming | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
| How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions | |||
Threaded Mode
