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 > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Bart Smissaert > Sent: 14 October 2011 01:35 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables and > pivottables) > > I use SQLite extensively as a data source in Excel and have never come across > this problem. > Is use Olaf Schmidt's VB wrapper vbRichClient4 and vb_cairo_sqlite. > If you can send me a workbook that clearly demonstrates the problem then I > can see if I can deal with it with the above wrapper. I am sure there will be no > problem at all. > > RBS > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
