[AccessD] Plotting datapoints to Excel

Darryl Collins darryl at whittleconsulting.com.au
Tue May 8 23:49:48 CDT 2012


If you want to send me a sample of what you have and an example of what output you require, I can have a peep at it if you like.  It would be done in Office 2010 though... we don't even have 2003 here anymore...



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, 9 May 2012 2:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Plotting datapoints to Excel

Nope, the other way around.  The data is in a database.  i can compile and export it into a text file or whatever just fine.  Only summary data goes into the spreadsheet in several sections which are then totalled up in the pre-programmed totals sections that are part of the spreadsheet template.  All the compiling of the data from detail is done in the database, which gets no detail at all.  It gets stuck into designated cells in the spreadsheet based on the intersection of two month/year coordinates.  It just seems like such a backwards way to using both Excel and Access that it makes me slightly crazier than usual.  This isn't really a report in any sensible meaning of the word, but government agencies require information regurgitated to them in a predefined format based on arbitrary rules, so I'm trying to figure out the most durable way to make it work on an ongoing basis without needing to hand modify the code every time a quarter's data gets added to the output.

Charlotte Foust

On Tue, May 8, 2012 at 6:36 PM, Mark Simms <marksimms at verizon.net> wrote:

> Charlotte - I understand, but I think this problem has really gotten 
> to you... ;) My rec was related to getting that Excel data into a 
> disciplined database format.
> Wasn't that the original intention ?
>
> > There is no flexibility in the Excel end.  We are not allowed to 
> > make any changes except to add rows and columns if needed to expand 
> > the range.
> > The
> > only practical thing I can do is temporarily pop in some code in 
> > Excel to parse data into the the data points.  It isn't a pivot 
> > format per se, although I suppose that's what they were aiming for.  
> > Anyhow, it will probably come down to exporting the data into a 
> > fixed width text file and then reading it into the Excel sheet to 
> > fill in the appropriate blanks from a macro in Excel.  After that, 
> > delete the macro and send them the spreadsheet.  Understand that 
> > we're dealing with a network environment where virtually nothing is 
> > run locally.
> > Charlotte Foust
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list