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
|