| From: | Dana Hudes <dhudes(at)tcp-ip(dot)info> |
|---|---|
| To: | Kumar <sgnerd(at)yahoo(dot)com(dot)sg> |
| Cc: | psql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Import from Ms Excel |
| Date: | 2004-03-16 12:13:53 |
| Message-ID: | Pine.LNX.4.58.0403160711110.11286@screamer.tcp-ip.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cristi | 2004-03-16 12:13:57 | conversion of postgres database to oracle |
| Previous Message | Achilleus Mantzios | 2004-03-16 12:08:24 | Re: Import from Ms Excel |