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 [EMAIL PROTECTED] www.captainjack.com ----- Original Message ----- From: "Jason Murray" <[EMAIL PROTECTED]> To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "php-general" <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
