Why is No data is sent to Excel from Access report?

[Ann in Bend]

I am running Excel 2000 and Access 2000 on Windows XP Home. When I send a
report to Excel from Access, an Excel file is created but no data goes to the
Excel file. The link to Word does work. Any suggestions? Options I am not
aware of?

 

[George Nicholson]

Sending Access reports to Excel isn't a sure thing. A lot depends on how the
report is formatted. If the report is close to a pure tabular format, it may
work well. The further from that you get with formatting (indented lines,
sections, etc.) the more likely you are to get garbage, or even what may
appear to be nothing.

Since you say the export to Word "works" then one work around I have used
may also work for you. Export to Word and then Ctl-A (Select all). Paste
that into Excel. (actually, I find that Paste and then PasteSpecial>Text
works best for me)

Otherwise, export the query the report is based on into Excel. Queries are
in tabular form so they always export.

HTH,