Re: Import from Ms Excel

Поиск
Список
Период
Сортировка
От Dana Hudes
Тема Re: Import from Ms Excel
Дата
Msg-id Pine.LNX.4.58.0403160711110.11286@screamer.tcp-ip.info
обсуждение исходный текст
Ответ на Import from Ms Excel  ("Kumar" <sgnerd@yahoo.com.sg>)
Список 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 по дате отправления:

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Import from Ms Excel
Следующее
От: "cristi"
Дата:
Сообщение: conversion of postgres database to oracle