Analyzing Access Report in Excel - Error

[JudyB]

I have been using the OfficeLinks "Analyze It with MSExcel" feature to send
a report to Excel for analysis purposes. This has been working fine, until
recently. I now get a message "Errors were detected in report.xls, but
Microsoft Excel was able to open the file by making the repairs listed
below. Save the file to make these repairs permanent. - Renamed invalid
Sheet name." We are using an Access 97 database, and sending it out to
Excel 2002. Any ideas on how to fix? Any help would be greatly
appreciated!! Thanks - JudyB.

 

[Brian]

Judy:

I've run into similar situations and have been given
every 'possible reason', which doesn't really help. One
thing that I have tried, which seems to work better is to
use the Export function, instead of the links. I believe
there is a problem with certain types of data coming out
of Access that it cannot convert 'correctly' for Excel.
Also, the links can/do truncate data, whereas the Export
does not.

Hope this helps.