Export to Excel - Data Tyoe changes from Text to Numeric, Grp Footers lost

  • Thread starter Thread starter SK
  • Start date Start date
S

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
 
SK:

You are correct that calculated controls like those on your groiup footer
will not export.

Regarding the data type conversions, these are hard to control. On export
to, as well as import from Excel, it's the first row of data transferred
that determines what the field type will be evaluated as on conversion. If
as in your example, the first row has "01" and it can be evaluated as a
number, then that is what it will be converted as on export. One way to
work around this is to wrap your value in the Cstr() function in the
underlying query and export the query rather than the report itself.
 
Back
Top