Re: how do I load a CSV file into a database table ???
From: a_blonde@mindless.com
>
> ---- 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
And if he goes out of the session? :-p
Anyway, _you_ *always* type at least 4 letters too many. :)
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com