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: [email protected]
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]
-----------------------------------------------------------------------------
