> On 12/6/15, Thomas Morris <morristc at me.com> wrote: > >> 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? >>
> Hi Gunter, > > Where would I get the CSV module from? > > regards, Robert > Hello, There has been a project over on Sourceforge that is a module for CSV with a JDBC for years. Several other Java applications are also out there that will do the work, including mine, MyJSQLView. Mine does not export BLOB, doesn't seem to make sense in that format to me, do it in SQL instead. I may to look change that though, I'll take a look. Sourceforge: https://sourceforge.net/projects/csvjdbc/ MyJSQLView io last code: http://code.google.com/p/myjsqlview/source/browse/trunk/myjsqlview/src/com/dandymadeproductions/myjsqlview/io danap
