Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Question, need quick answer please
Is there a way - in excel, to run SQL like queries on a sheet of data within the same workbook
E.g. Sheet1 has data In sheet 2, macro runs "SELECT * FROM Sheet1 WHERE Sheet1.Col1 < 5" I know there is ways to simulate this (by looping data) but I need to do several different parameterised queries Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Question, need quick answer please
You can use ADO to look at sheets within a workbook, but this can only be on
a file saved to disk, not the open workbook. It can be the same workbook as the open one, but it will look at the saved version. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stevie_mac" wrote in message ... Is there a way - in excel, to run SQL like queries on a sheet of data within the same workbook E.g. Sheet1 has data In sheet 2, macro runs "SELECT * FROM Sheet1 WHERE Sheet1.Col1 < 5" I know there is ways to simulate this (by looping data) but I need to do several different parameterised queries Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SIMPLE QUESTION need fast answer please | Excel Worksheet Functions | |||
Simple Question, But No Answer | Excel Worksheet Functions | |||
Quick answer please! | Excel Worksheet Functions | |||
Another Quick Simple VBA question (if...then statement) | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |