JamesThePanda Posted March 2, 2009 Share Posted March 2, 2009 Hi I was wondering if there any good (free) tools out there that convert MySQL to excel. I'm have a major database problem lol Thanks James Link to comment https://forums.phpfreaks.com/topic/147570-solved-mysql-to-excel/ Share on other sites More sharing options...
beyzad Posted March 2, 2009 Share Posted March 2, 2009 What do you mean? You can easily use PHPMyAdmin! Link to comment https://forums.phpfreaks.com/topic/147570-solved-mysql-to-excel/#findComment-774677 Share on other sites More sharing options...
JamesThePanda Posted March 2, 2009 Author Share Posted March 2, 2009 How do I use php admin to turn it into a excel file. I have never realy had any experience with it Thanks James Link to comment https://forums.phpfreaks.com/topic/147570-solved-mysql-to-excel/#findComment-774711 Share on other sites More sharing options...
Mark Baker Posted March 3, 2009 Share Posted March 3, 2009 PHPMyAdmin won't turn your table/query results into an Excel file, but you can use it to generate a Comma-Separated Value (CSV) file, which can then be opened in Excel. If you want a genuine Excel file, then you need to use a library capable of writing in Microsoft's proprietary xls format Link to comment https://forums.phpfreaks.com/topic/147570-solved-mysql-to-excel/#findComment-775389 Share on other sites More sharing options...
fenway Posted March 4, 2009 Share Posted March 4, 2009 PHPMyAdmin won't turn your table/query results into an Excel file, but you can use it to generate a Comma-Separated Value (CSV) file, which can then be opened in Excel. If you want a genuine Excel file, then you need to use a library capable of writing in Microsoft's proprietary xls format Not than any of the data in the mysql table is likely to be anything other than text... Link to comment https://forums.phpfreaks.com/topic/147570-solved-mysql-to-excel/#findComment-776197 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.