Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How tp query a spreadsheet table?
Hi!
I would like to run a sql query by using vba on a table in the same workbook as my vba code resides. I don't want to migrate my data to Access, a text file etc. Basically what I want to do is: 1. Create a recordset. 2. Populate the recordset with the whole table 3. Query the recordset. Something like "Select * From XXX Where Nr = 1 Or Nr = 3" 4. Output the result in a new table. Is there a way to do this.??? I am using XP, Excel 2000. TIA Henrik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How tp query a spreadsheet table?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How tp query a spreadsheet table?
Many thanks! It seems to be what I have been looking for. Sorry to notice the memory leak otherwise it had been av very neat solution. I will try this one! Best regards Henrik *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
How to query a spreadsheet? | Excel Discussion (Misc queries) | |||
query a spreadsheet | Excel Discussion (Misc queries) | |||
Run Query, then Protect Spreadsheet | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |