Hi Frank, > So when referencing an SQLite database from Excel you also use the ODBC driver I guess.
I don't access SQLite this way. Only access through this VB wrapper. > I now use the C API directly Interesting. Why, if you had a well performing VB wrapper, did you go this route? > If anyone have any solution for this or any other, easier alternative way of accessing an SQLite database as a data source programmatically This is exactly what I do and no problem at all for example to produce a pivot table based on data from SQLite. RBS On Thu, Oct 13, 2011 at 8:10 PM, Frank Missel <i...@missel.sg> wrote: > Hi Bart, > >> boun...@sqlite.org] On Behalf Of Bart Smissaert >> No, the wrapper is not used that way and I don't think it can be used that >> way. >> The SQLite database is dealt with in VBA or VB6 code via this wrapper. >> I suppose you could compare it to using ADO with a DSN-less connection. >> >> RBS > > Okay, that's what I thought. > I did try the wrapper a couple of years ago and found it very well designed > and performing; I can also recommend it for VB 6, VBA or VBScript. > I now use the C API directly -- sort of my own wrapper for some special > purposes. > > So when referencing an SQLite database from Excel you also use the ODBC > driver I guess. > This brings me to my main remaining issue which is to avoid having to create > an individual data source for each SQLite database. > > If anyone have any solution for this or any other, easier alternative way of > accessing an SQLite database as a data source programmatically through the > Excel COM object model (in order to e.g. create a Pivottable), I would be > very eager to hear about it :-). > > > /Frank > > _______________________________________________ > 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