On 11/13/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
OK, thanks for the reply. I am using the same construction to write directly from Interbase to Access and that works fine.
I'm surprised. Learn something every day!
I can make an ADO recordset first from the Interbase data and write that to SQLite in a (double) loop, but it is a bit slow. Maybe I should write to text first (which is quite fast) and then write to SQLite. I am not sure though how to import text into SQLite.
If you write a loop to extract it you can insert it through the sqlite odbc on a separate connection. If you write CSV format files the command line program can read it, or you can download my importer (the source code is available for both too). -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
