Yes, if the OP is not familiar with VBA then that is the best option. If he is familiar with VBA then with the mentioned wrapper you could write a simple Excel add-in (.xla) that will allow you to dump data from SQLite to Excel.
RBS On Sun, Jul 17, 2011 at 12:56 PM, Baruch Burstein <bmburst...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
