Re: how do I load a CSV file into a database table ???

Posted in 1999

a_blonde@mindless.com — Thu, 16 Sep 1999 11:13:40 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > From: Anthony Farrell <anthony.farrell@dretec.com> > > > how do I load a CSV file into a database table ??? > > $ set DBDELIMITER=, > $ export DBDELIMITER > $ dbaccess yourdb> q > n > LOAD FROM yourfilename INSERT INTO yourtablename;> <ESC> > r Dude, you type too much. Just use: LOAD FROM yourfile DELIMITER "," INSERT INTO yourtable AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com