At 05:25 PM 8/9/2007, you wrote:
I use it mainly to manipulate data obtained from an Interbase database.
All the data will eventually be dumped to Excel.
I use 2 ways to move data from Interbase to SQLite.
One, via an ADO recordset after connecting to Interbase with ODBC. This
recordset will then be dumped to SQLite via the free VB wrapper from Olaf
Schmidt, dhSQLite. Very good and fast wrapper with a rich object model.
Two, via a custom Delphi dll that moves data directly from Interbase to
SQLite. This is maybe slightly faster than the first method, but not that
much difference. So, no ODBC with this method and no ADO recordset.
Moving data from SQLite to Excel is all done with dhSQLite. This wrapper can
be downloaed from: http://www.thecommon.net/2.html
Very much recommended for anybody who works with VB or VBA.
RBS
RBS,
So why can't you manipulate the data in Interbase? It's reasonably
fast.
Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
