sql in excel

[Gintaras]

I only can give example of using SQL with Excel.

Macro Database Help

Code:

Copy      Help

;Excel. As table name, use [worksheet name$]. First row is used for headers.
Database db2.Open(db2.CsExcel("$personal$\book1.xls"))
ARRAY(str) a2; int c2
db2.QueryArr("SELECT * FROM [Sheet1$] WHERE Country='USA'" a2 1)
for c2 0 a2.len
,out a2[c2]