RE: [PHP] import XLS sheet into DB

2008-08-16 Thread Simcha
ues(".$row.")"); } ?> -Original Message- From: Jason Pruim [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2008 12:29 PM To: Alain R. Cc: php-general@lists.php.net Subject: Re: [PHP] import XLS sheet into DB On Aug 15, 2008, at 4:29 AM, Alain R. wrote: >

RE: [PHP] import XLS sheet into DB

2008-08-15 Thread Boyd, Todd M.
> -Original Message- > From: Alain R. [mailto:[EMAIL PROTECTED] > Sent: Friday, August 15, 2008 3:30 AM > To: php-general@lists.php.net > Subject: [PHP] import XLS sheet into DB > > Hi, > > I would like to import content of an XLS sheet into a PostgreSQL DB > (table). > > How can i do th

Re: [PHP] import XLS sheet into DB

2008-08-15 Thread Jason Pruim
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

Re: [PHP] import XLS sheet into DB

2008-08-15 Thread Mario Guenterberg
On Fri, Aug 15, 2008 at 10:29:40AM +0200, Alain R. wrote: > Hi, > > I would like to import content of an XLS sheet into a PostgreSQL DB (table). > > How can i do that ? Your question is not php related ;-) Maybe, export the sheet as comma separated csv file and import it to postgresql. Happy cod