in reply to xl file to database

Further, Perl's database interface, DBI, isn't always (usually?) the best way to load large quantities of data into a DB. Most databases have their own bulk-loaders that are often much faster. For instance, MS-Access has an import function while Oracle has SQL/Loader.

-Tats

Update: /me shame-facedly changes PERL to Perl. Thanks anony-brother!

Replies are listed 'Best First'.
Re: Re: xl file to database
by Anonymous Monk on Jun 13, 2003 at 09:48 UTC
    Perl, not PERL!
[reply]
Re: Re: xl file to database
by EvdB (Deacon) on Jun 13, 2003 at 06:50 UTC
    Postgres has this too. There is a COPY command that you can find out more about through psql: 
    db=> \h COPY
Command:     COPY
Description: copy data between files and tables
Syntax:
COPY table [ ( column [, ...] ) ]
    FROM { 'filename' | stdin }
    [ [ WITH ] 
          [ BINARY ] 
          [ OIDS ]
          [ DELIMITER [ AS ] 'delimiter' ]
          [ NULL [ AS ] 'null string' ] ]

    [download]
    You can also copy a table to a file. This may not be available through DBI but you can always create the file and then system "psql < file_to_copy_in";.

    --tidiness is the memory loss of environmental mnemonics

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom