Don't know whether this is Access or Excel, but here goes.

I have a database which manipulates over 1 million records per day. I produce charts of the summarised data created using the Form, Chart wizard and it all works very well. Users have now expressed an interest in viewing the same charts in Excel without having to import the summarised data (sometomes reaching 50,000 records)into a workbook and recreate the charts. I know the charts are an OLE object created using Graph 8.0, but is there any way I can do the export in Access directly into an Excel workbook (or any other Office programme for that matter)?

Cheers!

This is what Access Help has to say about this:

"There are three ways you can use Microsoft Access data with Microsoft Excel or another spreadsheet program:

You can export a datasheet as unformatted data to Microsoft Excel or another spreadsheet program.

You can save the output of a datasheet, form, or report directly as an Excel (.xls) file or worksheet. This way, you can preserve most formatting, such as fonts and colors. Report group levels are saved as Excel outline levels, and a form is saved as a table of data.

You can also export the data from a table, query/view, datasheet, form, or report to an XML file which can then be imported into Excel."

Why don't you put this chart on a web page instead of Excel. It sounds like they want an easier interface, and the web is better than Excel. If they want to manipulate data, then you are going to have to export the data to Excel, like you say you don't want to.

HTH

mmcdonal