in reply to From excel to mysql...

Personally, I would use DBD::Excel (or DBD::CSV) to read the data, then immediately write into DBD::mysql using INSERT statements.

Of course, you could save the Excel file as a CSV and use whatever loader(s) MySQL provides to load the CSV file.

That said, whatever ends up working is the best thing to do.

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

In Section Seekers of Perl Wisdom