Export report into Excel

G

Guest

Hi! I want to export an Access 2000-report into Excel 2000. So far I have
tried creating a macro with the Outputto-Command. Unfortunately when I open
the Exel-file only the headlines have been transfered. Any ideas what to do?
Thanks
 
M

Marshall Barton

Martin said:
Hi! I want to export an Access 2000-report into Excel 2000. So far I have
tried creating a macro with the Outputto-Command. Unfortunately when I open
the Exel-file only the headlines have been transfered. Any ideas what to do?
Click to expand...


Since a report is a graphical/picture representation of your
data, it is not a good candidate for exporting to another
program for further processing. You would be better off
exporting the report's record source query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting report into Excel 1
export to exel 1
Report Export to Text File 8
Exporting Report to Excel 2
export access report into excel 3
Report export issue 2
Export report to excel ERROR - please help 3
Filtering a report used with OutPutTo Method 5

Top