> how to read Excel/OO files and somehow put them into an SQLite database > for better use.
Quite simple that. Basically: range > variant array > loop through array and write to SQLite. Let me know and I will post some example code. RBS On Tue, May 18, 2010 at 11:56 AM, Gilles Ganault <gilles.gana...@free.fr> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
