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 On Sat, Jun 22, 2019 at 12:28 PM p q <[email protected]> wrote: > 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? > > > On Sat, Jun 22, 2019 at 12:13 PM 'Ralf B' via weewx-user < > [email protected]> wrote: > >> hello >> >> is it possible to open (import) the weewx sql database (*.sdb) in excel? >> >> if yes, how? >> >> regard >> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/c4e8b9a2-b5b5-4d11-a609-7dface0911ea%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/c4e8b9a2-b5b5-4d11-a609-7dface0911ea%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Peter Quinn > (415)794-2264 > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CAA1SM23bUPwVz3SAPuTQ%2BaAFNDpQMNU0%3Dyi9TW_KR7Sbm6c3hg%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAA1SM23bUPwVz3SAPuTQ%2BaAFNDpQMNU0%3Dyi9TW_KR7Sbm6c3hg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDy7s0zR%3Dh%2B6kBY56iYLtoFz913b3vKtphjqweVh9Z%2BBA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
