Export MySQL table into MS Excel spreadsheet

dr_sad · 07-06-2005, 11:51 AM

Hi, all.
Help me, please.
I have a MySQL database on web server, and PERL scripts working whit it. All I need is a mechanism that can export a table from DB to client MS Excel spreadsheet and vice versa. It may be download/upload for user.
How can I generate MS Excel readable file on base of the MySQL table?
How can I read uploaded from user MS Excel file to insert date into MySQL table on PERL under Linux?

Thank You.

deiussum · 07-06-2005, 12:56 PM

I don't know much about the Excel format, but it may be easier to conver to/from a CSV format. It's an easy format that you can probably already find tools to import/export to MySQL, and Excel can also import/export it. And if you can't find tools to import/export to MySQL, it's an easy enough format to write your own import/export for.