Re: Import from Ms Excel - Mailing list pgsql-sql

From Dana Hudes
Subject Re: Import from Ms Excel
Date
Msg-id Pine.LNX.4.58.0403160711110.11286@screamer.tcp-ip.info
Whole thread Raw
In response to Import from Ms Excel  ("Kumar" <sgnerd@yahoo.com.sg>)
List pgsql-sql
Certainly you can export your spreadsheet in CSV and 
it will easily go into Postgresql database (after you
create the database and its tables).
If you want something more sophisticated, a program
in e.g. Perl could use one of the various library programs
to extract data in some other-than-straightforward 
manner (perhaps only certain columns or a certain set of regions?)
and then use one of the database libraries (e.g. DBI) to insert
into database.  The CSV export is the simplest approach.


On Tue, 16 Mar 2004, Kumar wrote:

> Dear Friends,
> 
> Is possible to import data from MS Excel sheet into postgres database 7.3.4 running on Linux 7.2
> 
> Thanks
> Kumar
> 


pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Import from Ms Excel
Next
From: "cristi"
Date:
Subject: conversion of postgres database to oracle