> My problem is that the data basis of the Pivottable will sometimes be millions of rows
OK, I haven't got that problem and my pivots are based on a sheet range. Sheet range is based on a variant array obtained from SQLite. I will need to check, but I think you can use an array for the basis of a pivot. RBS On Thu, Oct 13, 2011 at 8:36 PM, Frank Missel <i...@missel.sg> wrote: > Hi Bart, > >> Interesting. Why, if you had a well performing VB wrapper, did you go this >> route? > > 1. Implementing the wrapper in the project code would also take some coding, > and I found that using the C API would not be that much extra work. Thus I > could save a layer, which was good as the project had several other layers > already. > > 2. The project required heavy data loads. I thought that I could get better > performance and control of data validation, i.e. I could decide exactly how > much and what to have. > > 3. It was a bit fascinating to get to work close to engine -- minimalistic > and effective is always fascinating :-). > >> > 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. > > Interesting, how do you get the data from the table or view into Excel to be > the basis of the Pivottable? > Do you paste it to a worksheet (perhaps as arrays) that then becomes the > basis of the Pivottable? > > My problem is that the data basis of the Pivottable will sometimes be > millions of rows, i.e. many more than can be contained in a worksheet. > But when referencing the data source directly as a proper data source the > number of rows are not limited to the maximum number of allowed rows in a > worksheet. > > /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