Re: How do you convert an xls file into a sql file?

From: "Serguei Mokhov" <sa_mokho(at)alcor(dot)concordia(dot)ca>
To: <plam(at)lycos(dot)com>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: How do you convert an xls file into a sql file?
Date: 2002-04-04 06:04:36
Message-ID: 05f501c1db9e$9abd56a0$bb6afea9@gunn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

----- Original Message -----
From: "Patrick Pui Chuen Lam" <plam(at)lycos(dot)com>
Sent: Wednesday, April 03, 2002 10:32 AM

> How do you convert an xls file into a sql file?

You're on the wrong list a bit, Patrick, to ask this sort
of questions...

Anyway, save your xls file as a csv (comma-separated values), and
load it in. I don't recall exactly off-hand now, but there might be a contrib
package to import data from Excel to a PG db.

-s

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-04-04 06:27:49 Re: PGAccess 0.98.7 apostrophe insertion
Previous Message Dmitry Tkach 2002-04-03 21:55:56 A bug in gist code with fetch/move