On Sep 27, 6:35 pm, Nuno Lucas <ntlu...@gmail.com> wrote: > Some time ago I had to do something similar and decided to write a small > virtual table implementation to treatCSVfiles as just another table. > This works for my uses which is to import Excel and OpenOffice files. > > I cleaned up the code a bit (removed non-english comments and some use > of functions from internal libraries), add a sqlite3_extension_init() > and posted the zip for the sqlite3 extension module on the wiki [1]. > > [1]http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles > > The code is used on both Win32 and Linux platforms, but this zip only > includes a makefile for Linux. It uses iconv() to handle character set > conversions, so that must be available if compiling for windows (or just > make sure the source text file is already UTF-8).
Could you please provide some info as to how you would build this as an extension module on Linux? Thanks --Emyr _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users