Export data from a Report to Excel?

H

Hoopster

I have an Access Report that I am trying to export to an Excel Spreadsheet so
I can create Charts and Graphs. My problem is when the data is exported and
the Spreadsheet opens, there is no data. I am using Access 2000 and Office
2003. Is this a problem? I feel my Report is pretty simple. All I have is a
list of Flag Styles and the number of Pass, Repair & Rejected Flags. When the
Report runs, all the numbers are right but those numbers won't export to
Excel.
 
S

Stefan Hoffmann

hi,
I have an Access Report that I am trying to export to an Excel Spreadsheet so
I can create Charts and Graphs.
Click to expand...
This is nonsense. Export the underlying data source using the

DoCmd.TransferSpreadsheet

method.


mfG
--> stefan <--
 

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

Using Office Forms and dynamically updating the excel backend 0
Embed the same Excel multiple times 0
Export Report with Graph to Excel error 2495 1
Integrating information from Word to Excel (not mail merge) 1
Report exporting different data from what is on the report 1
Adding Cost Field to Appointment 0
Data changes when exporting a report to Excel 0
how to export the value of checkbox on a report in to excel 2

Top