On 17 August 2010 11:28, David Burstin david.burs...@gmail.com wrote:
S
Again, this would be useful for importing the raw data from Access. What
the client needs is to be able to import the generated reports, including
calculated fields, totals, formatting, etc. *exactly as they see it on
On Wed, Aug 18, 2010 at 9:35 AM, mike smith meski...@gmail.com wrote:
Odd. I see Excel as being a better app to do calculated fields/formatting
than Access.
True. But the data has to come from somewhere and they are pretty happy with
the Access application they have and the reports it
David,
I feel your pain :-(
On 17 August 2010 11:28, David Burstin david.burs...@gmail.com wrote:
Thanks Arjang. I appreciate yours and everyone's continued efforts to help
me solve this. Comments below.
SNIP /
Again, this would be useful for importing the raw data from Access. What
On Mon, Aug 16, 2010 at 3:47 PM, mike smith meski...@gmail.com wrote:
export to excel workbook seems to export to a xlsx (2007) format ok.
What did you test exporting? From a report in the report viewer? From a
table? From a query?
Cheers
Dave
I thought when I saw this that it shouldn't matter. My bad there, the
options are different. I was doing it from a table.
Would exporting it as xml work then?
On 16 August 2010 16:11, David Burstin david.burs...@gmail.com wrote:
On Mon, Aug 16, 2010 at 3:47 PM, mike smith meski...@gmail.com
On Mon, Aug 16, 2010 at 4:29 PM, mike smith meski...@gmail.com wrote:
I thought when I saw this that it shouldn't matter. My bad there, the
options are different. I was doing it from a table.
Would exporting it as xml work then?
Tried that too. Exported fine but then could not import to
Hi David. As a last resort you could write a .Net app to do the export,
using ODBC to get at the data in Access, and something like Farpoint Spread
to export to Excel
http://www.fpoint.com/netproducts/spreadnet/spreadnet.aspx.
On 16 August 2010 16:37, David Burstin david.burs...@gmail.com wrote:
On Mon, Aug 16, 2010 at 5:12 PM, Alan Heywood a...@heywood.id.au wrote:
Hi David. As a last resort you could write a .Net app to do the export,
using ODBC to get at the data in Access, and something like Farpoint Spread
to export to Excel
-boun...@ozdotnet.com [ozdotnet-boun...@ozdotnet.com] On Behalf
Of David Burstin [david.burs...@gmail.com]
Sent: Monday, 16 August 2010 3:28 PM
To: ozDotNet
Subject: Re: [OT] Does anyone know a good Access list?
On Mon, Aug 16, 2010 at 5:12 PM, Alan Heywood
a...@heywood.id.aumailto:a
Sent: Monday, 16 August 2010 2:09 PM
To: ozDotNet
Subject: Re: [OT] Does anyone know a good Access list?
On Mon, Aug 16, 2010 at 3:47 PM, Ian Thomas il.tho...@iinet.net.au wrote:
David, that should be possible, out of the box so to speak.
I just searched and found an Office article
_
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Ian Thomas
Sent: Monday, 16 August 2010 4:35 PM
To: 'ozDotNet'
Subject: RE: [OT] Does anyone know a good Access list?
I'm sure it's possible, David - so I will have a search online (I don't have
Thanks Arjang. I appreciate yours and everyone's continued efforts to help
me solve this. Comments below.
On Tue, Aug 17, 2010 at 11:10 AM, Arjang Assadi arjang.ass...@gmail.comwrote:
Hi David,
what about exporting into XML , CSV or some other cross compatible format?
As mentioned in my
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
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,
-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of David Burstin
Sent: Monday, 16 August 2010 1:29 PM
To: ozDotNet
Subject: [OT] Does anyone know a good Access list?
Or have an answer to this:
I'm helping a client with some problems they are having with an Access 2007
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
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.
17 matches
Mail list logo