Analyze it with Microsoft Excel

[Ryan]

I have a database that I converted from Access 97 to
Access 2002. One of the features we used with the Access
97 version was to Analyze the reports in Excel. The user
doesn't have permission to access the queries that run the
reports so we had them just run the 'Analyze this is
Excel' feature from the report. Well, in Access 2002 it
is acting very wierd. It converts some of the text values
into numeric scientific values. Has anyone else
experienced this? I'm hoping someone has a fix.

 

[eric]

I've just experienced the same with Access 2000 sr1.
text 07/25 goes to 37827

Found a fix yet?

 

[Ryan]

Nope, I sure haven't. I can't find anything anywhere on
this. You would think that a lot of people would be
having this problem.