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

Reply via email to