weewx database -> excel ?

[Ralf B]

hello

is it possible to open (import) the weewx sql database (*.sdb) in excel?

if yes, how?

regard

[p q]

Yeah. It is possible, but it's non-trivial. You need a ODBC data source for SQLite. Google sqlite odbc and you'll find some instructions. It's not that difficult, but it will take some figuring out.

Depending on what you need to do, it might be easier to use a DB Browser for SQLite. I use the one here: https://sqlitebrowser.org/

You can view and edit the database and create a CSV if you need to get it to Excel. 

What do you need to do in Excel?

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/c4e8b9a2-b5b5-4d11-a609-7dface0911ea%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Peter Quinn
(415)794-2264

[Thomas Keffer]

Or, just use sqlite3 to create a CSV file, which is easy enough to import into Excel.

Here's one example on how to do this: http://www.sqlitetutorial.net/sqlite-tutorial/sqlite-export-csv/

-tk

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAA1SM23bUPwVz3SAPuTQ%2BaAFNDpQMNU0%3Dyi9TW_KR7Sbm6c3hg%40mail.gmail.com.