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
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
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.
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
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
5 matches
Mail list logo