automated export from MySQL to Excel

[Richard Mossman]

I need to export a half dozen pieces of data from two tables to excel at 1 am each morning and save the .xls file to a specific folder. Can anyone help me with this?

I'm working in a corporate environment with a very paranoid IT department. So, I'm not sure I'll be allowed to download and install something like MySQL for Excel. So, if this could be done with only whatever comes with the commercial download, that would be best.

In Query Browser, the code is:

select firstname, lastname, home_phone, cell_phone, remote_address, work_address
from personal, address
where personal.id=address.id and conf_data > "2013-11-01"

The first four items are in the personal table and the last two are in the address table and linked by the two keys. No, these are not real tables or field names. I wouldn't really use a reserved word for a field name.

Thank you.