Error Exporting Access Report to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris A - 25 Jan 2005 20:58 GMT

Hi, Access Gurus.

I am trying to export Access Reports into Excel for analysis and each
time I export, I get the following message:

Microsoft Excel File Repair Log

Errors were detected in file

The following is a list of repairs:

Renamed invalid sheet name.

On the "reparied," exported Excel file, the column(field name) heading
that I orignally have on the reports are changed to the field ID
instead. Why is this happening? How can go about fixing this? Please
advise.

Thanks in advance for all your help.

Reply to this Message

CalhounRaccoon - 31 Jan 2005 23:33 GMT

I never send actual true reports to Excel from Access. You lose so much and
Excel has a hard time keeping the columns straight, since the report has
"floating" fields.

I would create a query with data that looks like the report, when taking to
Excel to play with. Yes, you would send it over with a "flat file" look,
repeating header info on each row, but at least you would be clear about what
you were working with.

If neccessary, and if the pattern of data is consistent, you could, if
needed, create a "cleansing" page, in Excel, that referred, using formulas,
to your data dump, on another sheet, that arranged the data into a prettier
format, but if your data fluctuated in number of rows, etc. that may be
tricky.

Excel just doesn't like reports. If you want a pretty picture--use
snapshot. If you want to edit the data--dump a query, not a report.

My $.02

CalhounRaccoon

> Hi, Access Gurus.
>
[quoted text clipped - 15 lines]
>
> Thanks in advance for all your help.

Reply to this Message