RE: [PHP] import XLS sheet into DB

2008-08-17 Thread Simcha
); mysql_query(insert into `table` values(.$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 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 coding

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