Transfering data from an Excel spreadsheet to database using PERL 1

[duckiebear]

I am new to PERL, and need some help. I have a web based application on a secure server that writes data to a flat file in Unix. I am trying to come up with a PERL script/program that will take the old data that was kept in an Excel spreadsheet and import it into my database. Any suggestions on how to get this to happen?

 

[Rieekan]

Take a look on CPAN for the Spreadsheet:arseExcel module. It works very well at doing what you're looking for.

- Rieekan

 

[duckiebear]

Thanks. That was a very useful tip. I'm reviewing the code on CPAN now.