I am also working on something like this but am taking a different approach. Basically I'm creating an Excell Add-in in VBA that adds a button to the Excel toolbar. When a user clicks it I take the highlighted rows and columns and verify that they are in the proper format and everything looks good then import them into the database with the MySQL ODBC driver and VBA. It's more work up front than your solution but for the PHB it's a lot more comfortable than learning a new custom application and process. To them it's just Office ;)
-----Original Message----- From: Jackson Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 12:16 PM To: Jay Blanchard; Phil Perrin; [EMAIL PROTECTED] Subject: Re: Import from Excel to MySQL 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
