Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL - array
Is there a way to run a SQL Select on an array in VBA? If I Dim an array like
Dim x(100,100) as integer, can I perform a select statement on it? Seems like you should be able to since it is like rows and columns from a spreadsheet and is like a small database. Thanks! Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL - array
dave k wrote:
Is there a way to run a SQL Select on an array in VBA? If I Dim an array like Dim x(100,100) as integer, can I perform a select statement on it? No, you cannot query an in-memory array. However, you could write the array to a worksheet e.g. Sheet1.Range("A1:CW101").Value = x then query the workbook e.g. SELECT F101 FROM [Excel 8.0;HDR=No;Database=C:\MyWorkbook.xls;].[Sheet1$] WHERE F1 < 0; Jamie. -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL - array
I was afraid of that, thanks.
Dave "onedaywhen" wrote: dave k wrote: Is there a way to run a SQL Select on an array in VBA? If I Dim an array like Dim x(100,100) as integer, can I perform a select statement on it? No, you cannot query an in-memory array. However, you could write the array to a worksheet e.g. Sheet1.Range("A1:CW101").Value = x then query the workbook e.g. SELECT F101 FROM [Excel 8.0;HDR=No;Database=C:\MyWorkbook.xls;].[Sheet1$] WHERE F1 < 0; Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |