On Tue, 18 May 2010 11:48:06 +0100, Bart Smissaert <bart.smissa...@gmail.com> wrote: >You can run SQL on sheet ranges. >Just need to make sure that the workbook is saved and closed as there is a bug >to do with ADO causing a memory leak.
Thanks for the tip. I'll investigate in-place querying in Excel and OO Calc, and if it proves not to work too well, investigate how to read Excel/OO files and somehow put them into an SQLite database for better use. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
