history.db

[GaryDN]

I'm trying to create some reports and wanted to access the data in history.db. I read that is is sqlite format but sofar I have not been able to access the data. Has anyone been able to open history.db, if so what how

thanks in advance

[Rupp]

What code are you using to access the database?

[rmasonjr]

I'm trying to create some reports and wanted to access the data in history.db. I read that is is sqlite format but sofar I have not been able to access the data. Has anyone been able to open history.db, if so what how

thanks in advance

It's a SQLite database, so try:
http://sqlitebrowser.sourceforge.net/

[GaryDN]

What code are you using to access the database?

ODBC and Access or Excel, the ODBC driver was for SQLite 3

[GaryDN]

It's a SQLite database, so try:
http://sqlitebrowser.sourceforge.net/

Thanks rmasonjr, that allows me to open, view and export the data. I was hoping to connect to it directly and just update some graphs.



I'll use this for now anyone been able to do a odbc or connect via excel directly?

[Rupp]

You can connect using System.Data.SQLite. Here's a web site that explains the code.

http://www.kirupa.com/net/sqllite_vb_pg1.htm

[rmasonjr]

Thanks rmasonjr, that allows me to open, view and export the data. I was hoping to connect to it directly and just update some graphs.



I'll use this for now anyone been able to do a odbc or connect via excel directly?

I tried using ODBC a while back, but gave up. I started researching a .NET SQLite connector, but didnt get around to installing it.

[Guest]

2 quick options

Could be overkill for what you are attempting. http://sqliteforexcel.codeplex.com/

Old but should work. http://www.ch-werner.de/sqliteodbc/

I currently transfer the current cost SQLite data too MSSQL express and use SSRS(Sql Server Reporting Services) reports to view the data. The express edition with advanced features(SSRS) is free.

[GaryDN]

Could be overkill for what you are attempting. http://sqliteforexcel.codeplex.com/

Old but should work. http://www.ch-werner.de/sqliteodbc/

I currently transfer the current cost SQLite data too MSSQL express and use SSRS(Sql Server Reporting Services) reports to view the data. The express edition with advanced features(SSRS) is free.

The odbc driver that you point out does not work. would have been nice. I'll take a look at the link and see. I like the idea of getting into sql. I have express edition installed. wish I had more time to play

thanks

[Guest]

Will work you just need to write the SQL

The odbc driver that you point out does not work. would have been nice. I'll take a look at the link and see. I like the idea of getting into sql. I have express edition installed. wish I had more time to play

thanks

I just tested the ODBC using Excel 2007 and it works. You will receive an error about no tables but if you just hit cancel and write the following SQL in the SQL pane you will get results into Excel.

SQL Statement - SELECT * FROM History

You can not use the Excel gui query builder with SQLite and the ODBC driver.
Regards
RT

[GaryDN]

I did get the ODBC driver to work. I had download the 64bit version which does not work at all. I installed the 32 bit (I have 64bit system) and that works great

thanks for everyones help