[OT] Does anyone know a good Access list?

2010-08-15 Thread David Burstin
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

Re: [OT] Does anyone know a good Access list?

2010-08-15 Thread Arjang Assadi
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,

RE: [OT] Does anyone know a good Access list?

2010-08-15 Thread Ian Thomas
David, that should be possible, out of the box so to speak. I just searched and found an Office article on the topic - http://office.microsoft.com/en-us/access-help/export-data-to-excel-HA0012241 22.aspx _ Ian Thomas Victoria Park, Western Australia _ From:

Re: [OT] Does anyone know a good Access list?

2010-08-15 Thread mike smith
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

Re: [OT] Does anyone know a good Access list?

2010-08-15 Thread David Burstin
Hi Arjang On Mon, Aug 16, 2010 at 3:46 PM, Arjang Assadi arjang.ass...@gmail.comwrote: 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 I saw this too.