Export MS Access 2007 report to Excel

[Jeevie]

Hi All

I need help. I have tried several forums and have not found anything close to what I am looking for. I have several MS Access reports with option to the user to export to Excel. Is there a way to restrict the header fields from being exported as it completedly changes the tabular look and is not required anyways.

Appreciate any help.

[potski]

I don't think you can do it using the existing Excel output button.

However... You could create a second report that only has the headers you want to export, then create a button that exports the "Excel Friendly" version.

Then its just an issue of re-training your users to press the right button !

Potski