[Perl-unix-users] Import Excel Spreadsheet into MySQL

2002-10-21 Thread Jacob Mangalyajyothy
Hi All, I use MySQL and Perl On a Linux server. I need to import into a MySQL table, the contents of an Excel spreadsheet selected by a user from his terminal over Internet. Does any one know of any scripts/tools/utilties for this. Thanks in advance. Jacob Joseph.

RE: [Perl-unix-users] Import Excel Spreadsheet into MySQL

2002-10-21 Thread Thomas_M
Henry, I think you got that backwards. What he wants is Spreadsheet::ParseExcel to extract content from the Excel files, and DBI and DBD::mysql to insert the data into the database. -- Mark Thomas[EMAIL PROTECTED] Internet Systems Architect User Technology Associates, Inc.