[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

from MySQL to MS Excel ...


Hi Friends,
I am looking for an easy and seamless way to export MySQL query output to MS Excel.
At this moment I am using MS Access 2003 as front-end for a MySQL database.
With MS Access I can easily send the output of queries on my database to MS Excel.
All I need to do is select Tools > Office Links > Analyze it with Microsoft Office Excel.
That's all. This applies to all kinds of MySQL queries, including WITH ROLLUP options.
In the manual I found: http://dev.mysql.com/doc/refman/5.0/en/doctoexcel.html
But this is too much trouble, and does not allow full functionality of MySQL queries.
Question: is it possible to create MS Excel files directly from MySQL ?
TIA, Cor


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.