Re: [SQL] Import from Ms Excel

2004-03-26 Thread Hans de Bruin
Kumar wrote: Dear Friends, Is possible to import data from MS Excel sheet into postgres database 7.3.4 running on Linux 7.2 Install the postgress ODBC drivers. Create a new access database. Create two linked tabels, one to a table in de database and one to the excel sheet. Use a insert into

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Jeff Eckermann
--- Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar > wrote: > > Dear Friends, > > > > Is possible to import data from MS Excel sheet > into postgres > > database 7.3.4 running on Linux 7.2 > > Yes. I find the easiest way is to export a > delimited fi

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Dana Hudes
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-straight

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Achilleus Mantzios
O kyrios Andrew Sullivan egrapse stis Mar 16, 2004 : > On Tue, Mar 16, 2004 at 01:42:45PM +0200, Achilleus Mantzios wrote: > > Another fancy lib (although not necessarilly pgsql specific), > > is the POI project from jakarta. > > You can read/write M$ XLS documents from java, and > > subsequently

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Andrew Sullivan
On Tue, Mar 16, 2004 at 01:42:45PM +0200, Achilleus Mantzios wrote: > Another fancy lib (although not necessarilly pgsql specific), > is the POI project from jakarta. > You can read/write M$ XLS documents from java, and > subsequently (via jdbc) manipulate pgsql tables. > > The good part is that

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Achilleus Mantzios
O kyrios Andrew Sullivan egrapse stis Mar 16, 2004 : > On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar wrote: > > Dear Friends, > > > > Is possible to import data from MS Excel sheet into postgres > > database 7.3.4 running on Linux 7.2 > > Yes. I find the easiest way is to export a delimited f

Re: [SQL] Import from Ms Excel

2004-03-16 Thread Andrew Sullivan
On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar wrote: > Dear Friends, > > Is possible to import data from MS Excel sheet into postgres > database 7.3.4 running on Linux 7.2 Yes. I find the easiest way is to export a delimited file from Excel and use the \copy command in psql. A -- Andrew Sul