MS Access 97 Report Export to Excel

[Muzaffar Siddiqui]

Hello everyone. I don't know whether this is a right forum to address my query or not but I need help to resolve my problem or you can direct my mail to someone concerned and know about it.

We have a MS Access application. My problem is, when I export the Access Report to Excel, it does not appear in excel as it was appearing in the access report and we lose the formatting and runtime calculations, i.e., the headings, colors, totals etc. in column headings only field names appear. My questions are:

What can I do to resolve this problem?
There is any patch available to resolve this problem?
Any third party product which can do this?
Or use any other report writer which can facilitate the export in Excel?

I will highly appreciate your response and many thanks in advance for it.

Thanks for your cooperation.
Best of my regards
Muzaffar

 

[amunafc]

It is impossible to export an MS Access 2007 report to MS Excel 2007. The feature has been disabled by Microsoft, However I hear that there is SP2 PATCH that has all the features. Please research and update your office with the SP2 patch

 

[boblarson]

It is impossible to export an MS Access 2007 report to MS Excel 2007. The feature has been disabled by Microsoft, However I hear that there is SP2 PATCH that has all the features. Please research and update your office with the SP2 patch

This is a 7 year old post. I think you are a bit late to the game and the user would not have Access 2007 as it was 2002 when they were posting.

 

[amunafc]

hahahahahahahaha kikikikikikikiiii |I thought this would have been 100% answer to this gentleman. I did check the date. I thank for reminding me to check the date be4 any reply.