Hi Frank, > But are you saying that you are use the wrapper itself as a data source in Excel?
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 On Thu, Oct 13, 2011 at 7:41 PM, Frank Missel <i...@missel.sg> wrote: > Hi Bart, > > Okay, but I thought that the wrapper was just for working with the SQLite > database and then later when you wanted to use the database as a data source > that you would then still use the ODBC driver. > > But are you saying that you are use the wrapper itself as a data source in > Excel? > And if so, how do you specify the wrapper as a data source? > > > /Frank > > >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >> boun...@sqlite.org] On Behalf Of Bart Smissaert >> Sent: 14 October 2011 02:21 >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables > and >> pivottables) >> >> Hi Frank, >> >> This VB wrapper is not an ODBC driver, so there is no DSN. >> The database file is set in the connection string: >> >> Function OpenDB([FileName As String], >> [EncrKey As String], >> [EnableVBFunctions As Boolean = True]) As > Boolean >> >> Member of vbRichClient4.cConnection >> >> >> RBS >> >> >> On Thu, Oct 13, 2011 at 7:11 PM, Frank Missel <i...@missel.sg> wrote: >> > Bart, thanks for the offer, but we found the cause of the problems in >> > the data type naming of the columns. >> > >> > Have you found a way to avoid having to define DSN's for each >> > individual database? >> > >> > /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