Thanks for the tip. It sounds promising and I will try that out. RBS
-----Original Message----- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: 06 December 2006 23:16 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Interbase to SQLite RB Smissaert wrote: > I think I might have asked this before, but I still haven't figured it out. > What would be the fastest way to move data from Interbase to SQLite? > I will have to do this in VB/VBA, unless I could use a dll written in for > example C or C++. > > Currently I get the data with the Intersolve ODBC driver, moving that to an > ADO recordset and I then loop through that recordset and move the data to > SQLite with inserts via the VB wrapper dll from TerraInformatica. > Speed is just about acceptable, but maybe somebody who has done this before > (Interbase to SQLite) could advise me about a better way to do this. > > > You might want to try CodeGear's (formerly Borland's) Turbo C++ Explorer. This is the new *free* version of their IDE that includes a development version of InterBase (20 users max) and their fast dbXpress drivers for InterBase. Since it is a C/C++ compiler you can use SQLite directly, or through one of the C++ wrappers. I suspect that this will produce an application that is about as fast a you will get for moving data from Interbase to SQLite. HTH Dennis Cote ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
