> 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
