How Do I Export a MySQL Database To an xls or cvs for Yahoo Store Upload?

Question

I am tryng to use Yahoo's Easy Upload Store Back-end. Problem is the upload feature accepts only cvs / spreadsheet info. I have an existing web site that was created by another developer using MySQL. I need to get the data out of that database without having to sit for the next 2 weeks copying and pasting into an Excel Spreadsheet. I'm getting frustrated! PLEASE HELP ME!

Answer 1

You probably can use MySQL to  generate a query to list all the info to a table that you want on a web page, then use Excel to import it to an xls or csv file.

After you have the web page, on Excel go to menu, data, get external data, new web query, 1st put the url, pick your options in 2. and 3. then ok button.

In a matter of few seconds to few minutes, all the data will be on the spreadsheet, you can do whatever you like from there.

Hope this helps.