On 20 Aug 2004 at 10:09, [EMAIL PROTECTED] wrote: > >>> Hmm... I use ASP.net, is there any instruction that I can use to use > ASP.net > >>> to export into excel or is there another way? > > Well, I know nothing of ASP.net, but you should be able to select from > mysql, then instantiate excel via COM to write the binary. > > Jeff > > > > > How do I export from mysql into excel format?
There is also a method of exporting to excel via HTML tables. The following: <table> <tr> <td>Row1 cell1</td> <td>Row2 cell2</td> </tr> </table> When saved with a .xls extension ( or sent to a browser via mime type *application/vnd.ms-excel* ) will be opened directly by Excel. You can also include styles / text formating / functions etc within the cells. I ues this as a method for customers to download data easily. You will still have to write your own code to do the export though. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]