reading ECM database

[enthurston]

I'm monitoring a commonly used washroom and have written a C++ (it's what I know) app to do the crunching and generate a report. I have been exporting the SQLite ecm1.db3 database to a csv and reading the csv to generate the reports. Is there a way to directly read the SQLite database so I don't have to go through the export process? I've done a lot of programming using C++ and Access, and I would think it would be similar to that, but I just need to be pointed in the right direction for the tools to use with my app.

Thanks

[ben]

I suggest downloading SQLiteMan (http://sqliteman.com/) or similar program and become familiar with the database structure.

Once familiar take a look at the following link: http://www.sqlite.org/cintro.html.

The export program was written in C#, I could provide the source if interested, send me an email ben(at)brultech.com.