-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of d...@dommel.be
Sent: Monday, March 23, 2009 11:28 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Export the results from a select to excel
Hello,
what is the fastest way to do this with the C-api?
tx,
Danny
Belgium
===
Hello, Danny from Belgium,
Do you mean fastest to program or fastest to run? Most any
reasonably-sized spreadsheet shouldn't take all that long to be
exported, regardless of method.
You can simply output your SELECT with tab or comma separators, then
Excel can read up the file.
If you need the spreadsheet to be fancy, with nice formatting and
headers pre-set, then I'll leave it to someone more knowledgeable to
respond.
The fastest method to *develop* would likely be to use the SQLITE3
utility program with a tiny script something like:
Sqlite3 MyDatabase.db 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