On 10 Apr 2013, at 12:39pm, "Simon Sawatzki" <[email protected]> wrote:
> I remember that it once worked for me, but unfortunately now it does not > anymore. I would be happy if somebody could help so that I can export and > import data as CSV for easy external editing. The software you describe in your post is not part of SQLite. I can't help you with it. If you want to export SQLite data as CSV I recommend you use the sqlite3 shell tool: <http://www.sqlite.org/sqlite.html> You want something like sqlite3 myDatabase.sqlite .mode csv .output myTable.csv SELECT * FROM myTable; .quit To import the data back in again you want DELETE FROM myTable; .import myTable.csv myTable You can download compiled versions of the shell tool for various platforms here: <http://www.sqlite.org/download.html> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
