Best way is to use a tool like "SQLite Database Browser" (or a similar tool). You can get it from http://portableapps.com/apps/development/sqlite_database_browser_portable or from http://sourceforge.net/projects/sqlitebrowser/files/sqlitebrowser/2.0%20beta1/sqlitebrowser_200_b1_win.zip/download. Open the database, select the table you need and select "Export as CSV" on the File menu. Excel can open csv files.
On Sat, Jul 16, 2011 at 4:28 AM, Dave Klein <pepsiki...@yahoo.com> wrote: > Can anyone out there tell me how I can take a SQLite database and open it > in Microsoft Excell? I'm not stupid but I don't know servers, I don't know > ODBC's all I know is according to a the software I use that my data is > stored in a SQLite database with the name SlotCar30.db and their website > says it can be viewed and modified in excell, but the steps are missing a > few details like.... Server names, OBDC,s and a whole lot more I don't > understand. Even SQLite website say something about SQLite.exe but the Zip > file has no .exe file in it. Please help me. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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
