-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] 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 <MyLittleScript.sql Where "MyLittleScript.sql" is: .separator '\t' .output MyExport.tab SELECT [my select statement here]; .output stdout .quit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
