Re: How do you convert an xls file into a sql file? - Mailing list pgsql-patches

From Serguei Mokhov
Subject Re: How do you convert an xls file into a sql file?
Date
Msg-id 05f501c1db9e$9abd56a0$bb6afea9@gunn
Whole thread Raw
In response to How do you convert an xls file into a sql file?  ("Patrick Pui Chuen Lam" <plam@lycos.com>)
List pgsql-patches
----- Original Message -----
From: "Patrick Pui Chuen Lam" <plam@lycos.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


pgsql-patches by date:

Previous
From: "Patrick Pui Chuen Lam"
Date:
Subject: How do you convert an xls file into a sql file?
Next
From: Bruce Momjian
Date:
Subject: Re: PGAccess 0.98.7 apostrophe insertion