Export to Excel - Loses Group Footers and Text Data type becomes Numeric

[SK]

Greetings,

I have two small questions:

1. I have Access 2000 and Office 2000. When I export the
results of a report(using Analyze with Excel), I noticed
that the group footers are lost. As a result, the sub-
totals are not there in Excel(and they exist in Access).
After a little bit of research, I noticed that this is
how is it is designed. Just want to get a confirmation
about this and see if somebody has come up with a good
workaround or alternative to this problem.

2. As a part of the same report, I have field that is
defined as a Text field with data "01", "09", "99"...etc.
The data appears fine in Access. However, when I export
it into Access(either via Analyze it with Excel or from
an RTF File), the colum shows only numeric values like
1,9,99, etc. How can I prevent this datatype conversion
from happening during the export?

Thanks in advance,

SK

 

[Steve]

Dear SK

Access treats the report in terms of fields, a footer is
information that is not contained in an Access table,
therefore it will not export to Excel.

You'll find that data from a Table / Query will export
into an Excel spreadsheet.

If you want to try exporting the report and footer, try
exporting it into Word. This should work.

Steve