Hi Access giants,

I would like to run a query in Access (button on a form) with the possibility to automatically export the results to a formatted Excel file with functions like 'wrap text', colored headings etc. I also noticed that for example values (columns) with type 'time' are shown as 1-1-1900 in excel after export.
Who can help me out?

Thanks all in advance for your help.

Cheers,

Rob, Belgium

For this sort of export, I generally use a recordset to hold the data going out, use the Excel library to allow Access to control Excel objects and a loop to populate the spreadsheet.

You can then create a new workbook object, pick a sheet from that workbook and format it how you need, and control which fields from the recordset go where in the worksheet.

Thanks for your help! You've saved me

You're welcome! Glad to know that it helped