export to excel workbook seems to export to a xlsx (2007) format ok. On 16 August 2010 15:29, David Burstin <david.burs...@gmail.com> 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 > -- Meski "Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough" - Adam Hills