Thanks and in fact I had a look at your text importer about an hour ago. Couldn't figure out the parameters though. How would these be if I wanted to do this.
Import a text file called ReadCode.txt to a database called ReadCode.db Database has one table called ReadCode with these fields: SUBJECT_TYPE, READ_CODE, TERM30 , TERM60 SQL to create the table is like this: create table ReadCode ( SUBJECT_TYPE varchar(5), READCODE varchar(5), TERM30 varchar(30), TERM60 varchar(60) ); Tried all sorts of constructions, but apart from making the .db file and the table nil happened, so no data moved. RBS -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: 14 November 2006 14:06 To: sqlite-users@sqlite.org Subject: Re: [sqlite] INSERT INTO with SELECT 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] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------