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

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


See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp

----- 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