I don't think the OP really cares about linking SQLite to a spreadsheet. If I'm reading him correctly, he's just looking for an easy way to populate SQLite database tables using a simple GUI he doesn't have to develop himself, and doesn't have to pay a lot of money for. In other words, he wants something that's as easy to use as stashing your data in an Excel table, but has the power of SQLite.
Will -- Will Duquette -- william.h.duque...@jpl.nasa.gov Athena Development Lead -- Jet Propulsion Laboratory "It's amazing what you can do with the right tools." On 12/7/12 7:47 AM, "Marcus Ilgner" <mar...@doo.net> wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >On Freitag, 7. Dezember 2012 16:38:05, David Bicking wrote: >>> From: Gilles Ganault <gilles.gana...@free.fr> >> >>> On Fri, 7 Dec 2012 13:37:45 +0000, Simon Slavin >> <slav...@bigfraud.org> wrote: >>> Use the free SQLite shell tool downloadable from the SQLite site. >>> >>> Write your own interface in PHP using the sqlite3 interface which does >>>exactly what you want. >> >>> Thanks but before I build my own, I wanted to check that no one had >>> already built a Windows application with SQLite embedded, available >>> either as free- or share-ware. >> >> It is a bit heavy, and not really what I think you are after, but you >>might want to look at Kexi (http://www.kexi-project.org/) It attempts to >>be an open source replacement for Access. It has the simpler bits of >>Access, but doesn't have VBA, which is a deal breaker for me. >> >> >> OpenOffice / LibreOffice has a built in database tool, including a >>spreadsheet like interface. I believe it can be set up to use an sqlite >>database for its back end. Frankly I could never get it to work for me. >> > >OpenOffice/LibreOffice Base could probably do the trick. To set it up, >you'll have to add the SQLite JDBC driver .jar to OO/LOs class path and >then choose "connect to existing JDBC database" (or something along >these lines) when creating the .odb file. >I vaguely remember setting up such a thing a few years back for someone >else and iirc it worked for the intended use back then. > >All the best >Marcus >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v2.0.17 (MingW32) >Comment: Using GnuPG with undefined - http://www.enigmail.net/ > >iQEcBAEBAgAGBQJQwg+qAAoJELuOTdgGQnyZbZUIAI9QspGL779FwRm29SjBtRLG >wkoWnbaK+xfjRz3rntVLYTTqZvA+/5K7XVkaU85F1wOy8lYdNM+X1c+kQxgEW8Z4 >lRsfT0zSDMKR74Vi3y3AfZcUf07tV8ynEEOaYAHr72am2cW+Hj0QO4RHEi7jnsIu >qz+l0aMk8b7TljRMx/1ou4yWxt0UN9SvhiuFiUjTti5B+VdAnnMydlZYMDwBtdAz >bQpElrpTUgLi1leuBs9i9/He8tsHhJ6LfE0tqtSFWJZLRRdDugqnBx6HmAdUNQVE >OvNYoWnZxO1Ae73gWxHfEMH/kkOdsBywNsfYIfGJJlu34X0bW6pavVq6QhjeLn0= >=gzHN >-----END PGP SIGNATURE----- > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users