Export data from a Report to Excel?

G

Guest

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

how to export the value of checkbox on a report in to excel 2
Report exporting different data from what is on the report 1
Access report export to Excel 1
Export report data to Excel 10
Transfering an Access Report to Excel 1
Trying to Export Report to Excel 2003 16
Export Report to Word Document 1
Export to Excel Cuts Off Data 1

Top