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
