Re: import XLS sheet into DB

From: Date: Fri, 15 Aug 2008 10:29:00 +0000
Subject: Re: import XLS sheet into DB
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-278123@lists.php.net to get a copy of this message
On Aug 15, 2008, at 4:29 AM, Alain R. wrote:
Hi, I would like to import content of an XLS sheet into a PostgreSQL DB (table). How can i do that ? thanks a lot, A.
Alain, I haven't done it with PostgreSQL... But assuming it's not far from MySQL just save the excel file as a csv, or a tab separated file and import that. If you find away to import a strict xls file let me know, I have a project that could really benefit from that :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com japruim@raoset.com

« previous php.general (#278123) next »