DDE Link to chart in excel

  • Thread starter Thread starter V80
  • Start date Start date
V

V80

Hi

Can anyone tell me a quick and easy way to pass the results of a query in
access into excel to chart data through a DDE link ? I'm aware there is
charting functioanlity in access, but it has proven to be rather inflexible
in my experience.

Thanks
 
Access used to have an OfficeLinks button from which you could select
"AnalyzeItWithExcel," but they seem to have done away with this feature.
It was quick and easy, but the main drawback was that you couldn't
specify which folder or directory you wanted the data exported to. Try
selecting (not opening) your query, then use File | Export to save the
data to a workbook in the destination your choose. You can also copy and
paste recordsets to blank spreadsheets.

hth,

LeAnne
 
Back
Top