putting mysql data into an excel spreadsheet

[Sarah Atkinson]

I want to take data from a MySQL database and stick it into an Excel Spread sheet so the speadsheet is upto date and with data format intact. any easy way to do this?

ADDED:
I don't want to just drop data into the spread sheet. Diffent bits have to go in different places. Basicly the fields names arn't going to be the colum names ect.

[ergophobe]

Spit out the data in the format desired as a CSV file and then just read that into Exel. Very easy and can be done in reverse too if need be.