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 -----Original Message----- From: Gilles Ganault [mailto:[EMAIL PROTECTED] Sent: 09 August 2007 22:46 To: sqlite-users@sqlite.org Subject: [sqlite] [Visual Basic] How do you work with SQLite? Hello I was wondering: how do you VB developpers work with SQLite? Currently, I use a variant array that I fill with data from SQLite, and use ComponentOne's grid object to display the data through its LoadArray() method; If/once the data is updated by the user, I write the array back to SQLite. Do you use ADO et al? Other ways to connect VB and SQLite? Thank you. ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
