exporting reports from access to excel with proper formatting

[ds_8805]

hello everyone.. I have created reports in access and would need to export it to excel with proper formatting .. like for example the the font for the header shouldbe bold etc.. I have managed to export the files successfully by vba code but I am not able
to do it with proper formatting. I am a newbie at this and any help wld be greatly appreciated!


Thanks!

[llkhoutx]

Formatting to a great extent will be lost on the export. However, you can use Access vba to format the Excel spreadsheet.

[ds_8805]

Thank you very much for help