Hi Gunter, Where would I get the CSV module from?
regards, Robert On 07/12/15 08:26, Hick Gunter wrote: > You can always write a virtual table for exporting to whatever flavor of CSV > you like. Mine exports/imports strings/blobs containing nonprintable > characters in x'<hex data>' notation. > > Basically it implements: > > For export: > CREATE VIRTUAL TABLE <table>_csv_exp USING CSV (<filename>,<field list>); -> > create a CSV table with the indicated fields > INSERT INTO <table>_csv_exp SELECT <fieldlist> from <table>; -> write CSV > file (with header line) > > For import: > CREATE VIRTUAL TABLE <table>_csv_imp USING CSV(<filename>); -> read fields > from indicated filename > INSERT INTO <table> SELECT <fieldlist> from <table>_csv_imp; -> read CSV file > > -----Urspr?ngliche Nachricht----- > Von: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von > Thomas Morris > Gesendet: Sonntag, 06. Dezember 2015 19:44 > An: sqlite-users at mailinglists.sqlite.org > Betreff: [sqlite] Exporting > > I recently took over a Java based application that has SQLite embedded and > now I need to export the database into a CSV format. Reading online, I have > found that using (dot)mode csv, or any (dot) command is not possible when > SQLite is embedded, simply due to the (dot) commands being for use within the > shell. Is there an alternative way to export, other than by using (dot) > mode, or am I simply out of luck? > > Thomas > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: hick at scigames.at > > This communication (including any attachments) is intended for the use of the > intended recipient(s) only and may contain information that is confidential, > privileged or legally protected. Any unauthorized use or dissemination of > this communication is strictly prohibited. If you have received this > communication in error, please immediately notify the sender by return e-mail > message and delete all copies of the original communication. Thank you for > your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
