As for programming skills, I'm pretty familiar with Java so I feel sure I
could write a suitable utility with that. In fact, unless I had a really
urgent need, I would prefer to write my own stuff just because I like
writing code
If you wanted to go the java route I suggest checking out
http://jdbforms.sourceforge.net/wiki.php
which automatically generates jsp forms by reading your table definition. You can then add a simple button to export to excel such as:
<db:gotoButton caption="export_to_excel" singleRow="false" destTable="BOOK" destination="/excelReport/books?filename=BOOK.xls&sheetname=BOOKLIST" />
(example from dbforms/examples/bookstore/howto/howtoPrintaExcelReport.jsp)
so then regular users can use a web based form to insert/update/filter/sort the information and then export what they needed to xls.
This above example uses the Jakarta POI - Java API To Access Microsoft Format Files --http://jakarta.apache.org/poi/
Otherwise you could also use DbForms to pass the data to a JasperReport which allows excel output as well
http://jasperreports.sourceforge.net/ see dbforms/examples/bookstore/howto/howtoPrintaExcelReport.jsp also see the JasperReports Chapter of the UsersGuide for dbforms if interested on how to configure it.
dbforms also lets you do neat things like
Select type, sum(value) as sumValue where date < ? group by type having sumValue > ?
where because the date should be selected by the user, you can not use a fixed view in the database (see the dbform's usersguide chapter on Query Support)
Have a good one, -- Shawn
Karma is immutable, so act accordingly!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
