[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
>
>
>