export access report to excel

  • Thread starter Thread starter Kemi
  • Start date Start date
K

Kemi

Hi all:

I have a report in Access.

I am trying to move the report to Excel so that I can further edit it.

But the export is only exporting the header of my report.

Here is what I did:
I opened the report
Tools- Office- Analyze it with Microsoft Excel and gave the file name
and location.

But this is only exporting the header. I have done this a couple of
time before and it did export the whole report, I don't know what I am
doing wrong.

Please help.

Thanks a lot
 
I don't know what the solution is, as I'm having the same issue, but I have
noticed that the report that I try exporting that doesn't give me anything
in Excel is one that has detail.visible = false. I have 3 other reports that
I export data that all export fine but they all have detail.visible = true.
I don't know if that'll give anyone any ideas that might help solve the
issue :)
 
Back
Top