Export to Excel - Data Type changes from Text to Numeric, Grp Footers Lost

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel - Data Tyoe changes from Text to Numeric, Grp Footers lost 1
Export Report with Graph to Excel error 2495 1
Export to Excel - Loses Group Footers and Text Data type becomes Numeric 1
Export to Excel over context menu error: cannot diplay the webpage 0
Export Calendar / Exception Data to Excel: 0
Export Access pivot table to Excel - VBA solution 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Link Access to Excel export back to excel 3

Top