Hi David, I found this : Unless you install the Office 2007 suite Service Pack 2, you cannot export a report to an Excel format in Access 2007 http://support.microsoft.com/kb/934833
and this other less usefull one: http://www.access-programmers.co.uk/forums/showthread.php?t=137521 One question, do they have 2007 installed on the machine and it stills tries to export to 2003? Regards Arjang On 16 August 2010 15:29, David Burstin <[email protected]> wrote: > Or have an answer to this: > I'm helping a client with some problems they are having with an Access 2007 > application. They have reports based on queries with very large result set > (> 100,000 rows). They show up fine in the report viewer, but when they hit > "Export to Excel" (built in functionality of the Access report viewer), it > tries to export to Excel 2003, so exceeds the row limit. Excel 2007 can > easily handle this number of rows, but I can't find a way to export to it > instead of 2003. > Cheers > Dave
