I just had to solve this problem. I needed to be able to have users load an excel file from a browser and have it import.
To do this I used perl to have the excel convert to csv on the server. This was easy to accomplish using the CPAN module ParseExcel. The module comes with a sample script that basically does the trick. I am planning to use perl2exe to create an executable of my xls2csv perl script. But the perl script is working fine. I use exec() to call the perl script. -Jackson On Tuesday 19 August 2003 10:49, Jay Blanchard wrote: > [snip] > Basically I need a way to import them from the Excel sheet to the > database so at that point I can manipulate the data and use a php script > of some sort to run a whois after extracting the domain name, and then > return the results to the database and have it attached to the domain > name. > [/snip] > > Export the Excel to csv, then import the csv to MySQL. There are classes > for PHP that will read the binary data directly from Excel, but they are > costly...i.e. http://www.web-aware.com/biff/ > > HTH! -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
