My text file is only an intermediate and I can make the way I want. I need to move data from Interbase to SQLite. Fastest method sofar is: IB > ADO recordset ADO recordset > text file Import text file with SQLite .import command
Problem with .import is that it doesn't like double quotes. RBS -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: 16 November 2006 04:24 To: sqlite-users@sqlite.org Subject: Re: [sqlite] INSERT INTO with SELECT You should create your database and your table first. Do that in sqlite3.exe using your create table statement below. What format is your text file in? What separates one field from another? On 11/14/06, RB Smissaert <[EMAIL PROTECTED]> wrote: > 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) > ); > -- 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] -----------------------------------------------------------------------------
