Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables and
> pivottables)
>
> Hi Frank,
>
> You can take a look at my start-up file for excel 2000/2003:
>
> http://source.declera.com/excel/personal.xls
> (I am also attaching contained VBA module db.ba
Hi Frank,
You can take a look at my start-up file for excel 2000/2003:
http://source.declera.com/excel/personal.xls
(I am also attaching contained VBA module db.bas)
With started personal.xls [1], one can open empty sheet named "sqlite",
enter the path to sqlite database file in cell A1, and t
t 14, 2011 at 2:33 AM, Frank Missel wrote:
>> boun...@sqlite.org] On Behalf Of Bart Smissaert
>> Sent: 14 October 2011 04:05
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables
> and
>> pivottable
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Petite Abeille
> Sent: 14 October 2011 03:58
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] How to use SQLite as a data source in
> boun...@sqlite.org] On Behalf Of Bart Smissaert
> Sent: 14 October 2011 04:05
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables
and
> pivottables)
>
> It looks you can't make a pivot table directly
It looks you can't make a pivot table directly from an array.
What you could do though is write the array to a text file and base the array on
that file as an external data source via a text driver.
Another option is build your pivot table in code, not using the Excel
pivot table
object.
RBS
On
On Oct 13, 2011, at 9:36 PM, Frank Missel wrote:
> 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?
Pivot tables can be populated from
> 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
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
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
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
[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
e
> 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],
>
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:
ers-
> 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
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
>
> would something like
>
> SELECT CAST (theValue AS REAL) AS thisValueReal FROM ...
>
> force the driver to recognise that the value it was getting was REA
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
On 13 Oct 2011, at 5:48pm, Frank Missel wrote:
> "The problem is the typelessness of SQLite. In order to obtain column
> information early, a SELECT is prepared twice. The first gives the column
> names and potential type information.
>
> In the second phase the second select retrieves data. For
I am trying to use data from an SQLite database as a data source for a
Pivottable in an Excel sheet.
By use of Micrsoft Query and the SQLite ODBC driver I can reference a table
from an SQLite database either as a list in a worksheet or as basis for a
Pivottable. This apparently works fine. Howe
19 matches
Mail list logo