Steve, You might try installing this ODBC driver that allows you to query a Sqlite db just like Access, Excel, etc with Adodb. You can use VB6, VBA, vbscript.
http://www.ch-werner.de/sqliteodbc/ The connection string is like this: objConn.Open "DRIVER=SQLite3 ODBC Driver;Database=C:\sqlite\test-2.3.sqlite" Keith Steve Ely wrote: > > My mistake. I had read that SQLite had an ActiveX, I guess they were > refering to 3rd party vendors. Can anyone reomend a good one for VB? > > --- On Wed, 1/5/11, Pavel Ivanov <[email protected]> wrote: > > > From: Pavel Ivanov <[email protected]> > Subject: Re: [sqlite] ActiveX documentation > To: "General Discussion of SQLite Database" <[email protected]> > Date: Wednesday, January 5, 2011, 4:38 PM > > >> Can any one direct me to the documentation for the Windows ActiveX >> control? >> I found the zip on the download page but it only contains sqlite3.dll and >> sqlite3.def. > > If you are talking about sqlite3.dll from sqlite.org website then you > are wrong: it's not an ActiveX control. It's just a library with a set > of C functions, that's it. There's documentation on all of those > functions on the same website sqlite.org. > > > Pavel > > On Wed, Jan 5, 2011 at 5:05 PM, Steve Ely <[email protected]> wrote: >> Can any one direct me to the documentation for the Windows ActiveX >> control? >> I found the zip on the download page but it only contains sqlite3.dll and >> sqlite3.def. >> >> Thanks, >> Steve >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/ActiveX-documentation-tp30600564p30630735.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
