Re: [sqlite] I havn't a clue

2011-07-17 Thread Bart Smissaert
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 wrote: > Best

Re: [sqlite] I havn't a clue

2011-07-17 Thread Baruch Burstein
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. Op

Re: [sqlite] I havn't a clue

2011-07-17 Thread Bart Smissaert
Best way to do this is probably with a VB SQLite wrapper and I would recommend this one: http://www.thecommon.net/3.html Download from this link. The Toolset-Binaries: (ca. 1.8MB) There is example code showing you how to use it. If you get stuck I can mail you a workbook that demonstrates it all.

Re: [sqlite] I havn't a clue

2011-07-15 Thread Igor Tandetnik
On 7/15/2011 9:28 PM, Dave Klein wrote: > Can anyone out there tell me how I can take a SQLite database and open it in > Microsoft Excell? There exist ODBC drivers for SQLite (I'm sure your favorite search engine can help you find them). Set up an ODBC source for your database, then Excel will

[sqlite] I havn't a clue

2011-07-15 Thread Dave Klein
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 say