FAQ

[PostgreSQL] insert data from an microsoft excel

Nageshwar Rao
Feb 16, 2005 at 11:16 am
Is there is way to load data from as Microsoft excel into database tables in
postgresql7.4.x
Thx
Rao
reply

Search Discussions

5 responses

  • John DeSoi at Feb 16, 2005 at 12:48 pm

    On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:

    Is there is way to load data from as Microsoft excel into database
    tables in postgresql7.4.x

    Sure. Export the data into a CSV file. Then import it using psql and
    the \COPY command.

    http://www.postgresql.org/docs/8.0/interactive/app-psql.html
    http://www.postgresql.org/docs/8.0/interactive/sql-copy.html


    John DeSoi, Ph.D.
    http://pgedit.com/
    Power Tools for PostgreSQL
  • Matt Kynaston at Feb 16, 2005 at 1:32 pm
    John DeSoi wrote:
    On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:

    Is there is way to load data from as Microsoft excel into database
    tables in postgresql7.4.x


    Sure. Export the data into a CSV file. Then import it using psql and
    the \COPY command.
    Or if it's something that needs automating, take a look at the ODBC
    driver. There's a howto on using VBA to connect Access to Postgres -
    Excel will be similar:
    http://gborg.postgresql.org/project/psqlodbc/
    http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-accessvba

    Matt
  • David Fetter at Feb 16, 2005 at 2:49 pm

    On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
    Is there is way to load data from as Microsoft excel into database
    tables in postgresql7.4.x
    Once you've upgraded to 8.0x--a good idea anyhow--you can use DBI-Link
    with the DBD::Excel driver.

    http://pgfoundry.org/projects/dbi-link/

    Cheers,
    D
    --
    David Fetter david@fetter.org http://fetter.org/
    phone: +1 510 893 6100 mobile: +1 415 235 3778

    Remember to vote!
  • Ed L. at Feb 16, 2005 at 3:06 pm

    On Wednesday February 16 2005 7:48, David Fetter wrote:
    On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
    Is there is way to load data from as Microsoft excel into
    database tables in postgresql7.4.x
    Once you've upgraded to 8.0x--a good idea anyhow--you can use
    DBI-Link with the DBD::Excel driver.
    Wouldn't ODBC work for this?? I've pulled into Excel from Pg as
    far back as pg 6.5, but never tried pushing from Excel into
    Pg...

    Ed
  • David Fetter at Feb 16, 2005 at 3:33 pm

    On Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote:
    On Wednesday February 16 2005 7:48, David Fetter wrote:
    On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
    Is there is way to load data from as Microsoft excel into
    database tables in postgresql7.4.x
    Once you've upgraded to 8.0x--a good idea anyhow--you can use
    DBI-Link with the DBD::Excel driver.
    Wouldn't ODBC work for this??
    It probably would.
    I've pulled into Excel from Pg as far back as pg 6.5, but never
    tried pushing from Excel into Pg...
    DBI-Link makes it pretty trivial to pull any tabular data into
    PostgreSQL :)

    Cheers,
    D
    --
    David Fetter david@fetter.org http://fetter.org/
    phone: +1 510 893 6100 mobile: +1 415 235 3778

    Remember to vote!

Related Discussions

Discussion Navigation
viewthread | post