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.
Stefan Hoffmann - 19 Jan 2007 10:26 GMT
hi,
> I have an Access Report that I am trying to export to an Excel Spreadsheet so
> I can create Charts and Graphs.
This is nonsense. Export the underlying data source using the
DoCmd.TransferSpreadsheet
method.
mfG
--> stefan <--