Re: reading excel file

Thanks Jason, that is a pretty good idea. Any idea how well PHP handles large ammounts of data like that? There'll be about 25,000 lines in every excel file, and they come in groups of 5 or 6. Tyler Longren Captain Jack Communications tyler@captainjack.com www.captainjack.com ----- Original Message ----- From: "Jason Murray" <Jason.Murray@melbourneit.com.au> To: "'Tyler Longren'" <tyler@captainjack.com>; "php-general" <php-general@lists.php.net> Sent: Tuesday, April 02, 2002 7:32 PM 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