RE: [PHP] reading excel file

If you are running your server on windows, you may also have the option of using COM to access Excel to open the file and read the information contained in each cell, See http://www.php.net/manual/en/ref.com.php Warren Vail Tools, Metrics & Quality Processes (415) 667-7814 Pager (877) 774-9891 215 Fremont 02-658 -----Original Message----- From: Jason Murray [mailto:Jason.Murray@melbourneit.com.au] Sent: Tuesday, April 02, 2002 5:33 PM To: 'Tyler Longren'; php-general Subject: RE: [PHP] reading excel file > Has anyone ever converted an excel file over to a MySQL database > via PHP? I'm currently doing it with perl, and this isn't a very > good option for me. The client needs to login to a server via ssh > every time they want to put data from their excel file to mysql. > I'd like to find some way to do it through a web browser. If you can get them to save the Excel file as tab-delimited, you could just read it, explode on \t and assemble your SQL insert statements. Failing that, you could continue to use the Perl script but accept the Excel file as a HTTP upload, and have PHP run the Perl script. J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php