[AccessD] Plotting datapoints to Excel

Mark Simms marksimms at verizon.net
Tue May 8 20:36:00 CDT 2012


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




More information about the AccessD mailing list