J
JoeA2006
I have developed a fairly complicated report in Access based on a dozen or so
subreports with quite a few calculated fields on the main form. Now the users
want to be able to work with this data in Excel. Simply exporting the report
to Excel does not work, because Excel wants to put each field in its own
column. So far my research has lead me to two basic paths.
1. Save the report in HTML and then perform a web query. (This almost works
except the data does not always land in the correct columns and does not line
up with Headers or totals.) I did find article 209145,which suggests embeding
a snapshot viewer Active X control in the webpage, which I have not tried as
of yet.
2. Try to import all the queries into Excel with a macro, and somehow format
the spreadheet dynamically.
The html solution seems make the most sense. Has any one had any experience
with this ?
2. T
subreports with quite a few calculated fields on the main form. Now the users
want to be able to work with this data in Excel. Simply exporting the report
to Excel does not work, because Excel wants to put each field in its own
column. So far my research has lead me to two basic paths.
1. Save the report in HTML and then perform a web query. (This almost works
except the data does not always land in the correct columns and does not line
up with Headers or totals.) I did find article 209145,which suggests embeding
a snapshot viewer Active X control in the webpage, which I have not tried as
of yet.
2. Try to import all the queries into Excel with a macro, and somehow format
the spreadheet dynamically.
The html solution seems make the most sense. Has any one had any experience
with this ?
2. T