That old chestnut Exporting a Report to Excel!

[digger]

I have several databases I maintain which are currently in Access 2003 format, however several of my clients want to upgrade to Access 2007. I have successfully transfered the custom toolbar in Access 2003 to a Menu Bar in 2007 and removed the Ribbon from view. The problem I have is that the 'Export to Excel' icon on my custom Menu bar gives me the following error:'The format in which you are attempting to output the current object is not available'. I have set my Excel to save in 97-2003 format and if I allow the Ribbon to show and use the Icon to Export to Excel from there it works. Does anyone have any suggestions as I really need to use the existing Menu Bar Icons if at all possible! I have applied SP2 to my Access 2007.

 

[shadow9449]

The problem I have is that the 'Export to Excel' icon on my custom Menu bar gives me the following error:'The format in which you are attempting to output the current object is not available'. I have set my Excel to save in 97-2003 format and if I allow the Ribbon to show and use the Icon to Export to Excel from there it works. Does anyone have any suggestions as I really need to use the existing Menu Bar Icons if at all possible! I have applied SP2 to my Access 2007.

The claim is that you can export reports to Excel in Access 2007 if you apply SP2. I have tried it on several computers with no luck. I hope that someone can solve this mystery.

It certainly makes me wary of purchasing Access 2010. There's nothing telling us that Microsoft won't remove some important functionality with no advance notice and then claim that it will be resolved in a few years with some service pack.

SHADOW

 

[georgedwilkinson]

Spam in post #2 reported.

 

[shadow9449]

Spam in post #2 reported.

Hi George

I just noticed this post now. Where is the spam in my post that you refer to?

Thanks

SHADOW