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.

--