extract DB data to Excel

[npereira]

Is it possible to extract the DB content (from MySQL) to an excel spreadsheet that the users can then download on their PC for mailing list label making and other stuff?

Thanks in advance for your reply.

Nelson

[gid]

You can loop through the rows and write to file and name it ending in .csv

Basically you want the csv file to look like this:

"Field Name 1", "Field Name 2", "Field Name 3"
"Data 1", "Data 2", "Data 3"
"Data 1", "Data 2", "Data 3"
"Data 1", "Data 2", "Data 3"
"Data 1", "Data 2", "Data 3"
etc