Baslinux mailing list

[baslinux AT lists.ibiblio.org]

> > sqlite 3
> > Also imports csv files.
> I can't figure out how this works.
> 
> I created database.csv which I wanted to make into database.db
> csv has comma rather than | as separator
> 
> sqlite3 database.db
> >.separator ','
> >.import database.csv database
> 
> (instructions are .import FILE TABLE)
> 
> TABLE appears NOT to refer to the name of my database file.

Nope, it refers to the table (e.g postamt in the original example).

You will need to create the table first (using the SQL CREATE TABLE command),
 then import the data into it.

Ian