Skip site navigation (1) Skip section navigation (2)

Re: Import from Ms Excel

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 (view raw or flat)
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
> 

In response to

pgsql-sql by date

Next:From: cristiDate: 2004-03-16 12:13:57
Subject: conversion of postgres database to oracle
Previous:From: Achilleus MantziosDate: 2004-03-16 12:08:24
Subject: Re: Import from Ms Excel

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group