Skip to Content.
Sympa Menu

baslinux - Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,

baslinux AT lists.ibiblio.org

Subject: Baslinux mailing list

List archive

Chronological Thread  
  • From: baslinux AT lists.ibiblio.org
  • To: baslinux AT lists.ibiblio.org
  • Cc: baslinux AT lists.ibiblio.org
  • Subject: Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,
  • Date: Tue, 15 Jul 2008 13:05:06 GMT


> > 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




Archive powered by MHonArc 2.6.24.

Top of Page