Re: import Excel file into PostgreSQL
| From: | Chris | Date: | Tue, 07 Aug 2007 06:39:59 +0000 |
| Subject: | Re: import Excel file into PostgreSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-260263@lists.php.net to get a copy of this message | ||
Alain Roger wrote:
HI, I would like to know the best and fastest way how to import some colums contents from Excel file to PostgreSQL database. how can i do that ? I mean some columns of Excel should be imported into a particular table and some others into another table.If it's a proper excel file, try something like: http://sourceforge.net/projects/phpexcelreader If it's a CSV file, try http://www.php.net/fgetcsv -- Postgresql & php tutorials http://www.designmagick.com/