As you are familiar with VBA I can see two other options:

1. Use Christian Werner's ODBC driver from Access (or Excel):

2. Use Olaf Schmidt's COM dll with Access (or Excel):


On Mon, Nov 13, 2017 at 9:54 PM, Balaji Ramanathan <> wrote:

> Hi,
>     I have been using SQLite without any programming language so far.  I
> maintain the data in SQLite and use SqliteStudio ( for
> inputting data into it and running queries to look at outputs.  However
> SqliteStudio does not have a programmable back-end that allows me to take
> the outputs of a query and do things with it (such as calculating running
> sums and averages, for instance).  So, if things become too expensive for
> standard SQL, I just do without.
>     In the past, I have maintained my data in an Access database and
> developed a pretty extensive set of forms and reports to input and extract
> data.  I moved to SQLite because I wanted to move off a proprietary
> platform onto a free one.  And SQLite is faster and includes more SQL
> functionality like CTE's also.
>     But I miss the nice front-end with forms to take inputs (especially
> parent and child forms to input data related to foreign keys) and the
> reports to format my outputs the way I wanted them.  I could also do
> running sums and averages, percentile scores and other things that require
> looking at a data dump of an entire columns of contents to do efficiently.
>     I am familiar with programming in C and Java, but none of my
> programming has been for the windows platform (except for the programming
> inside MS Access, which was done in VBA).  I have never developed GUI front
> ends with forms, buttons, etc.
>     Is there a third party free tool like MS Access that would allow me to
> connect to a SQLite db in the back-end and enable me to create a custom
> front-end to it with forms and reports?  All my searches for this kind of
> tool only lead me to tools like SqliteStudio, which is a GUI front end for
> SQLite, but not a programmable one like I want.  If anyone can point me
> towards a programmable GUI front-end development tool (preferrably
> open-source, but just free and well-maintained is sufficient), I would
> appreciate it greatly.
>     Thank you very much.
> Balaji Ramanathan
> _______________________________________________
> sqlite-users mailing list
sqlite-users mailing list

Reply via email to