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
 
You must log in or register to reply here.

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

Paste Excel Charts in PowerPoint as Linked Objects 1
PowerPoint Embed scroll excel chart and data in powerpoint 0
Real-time charting of DDE links 6
Creating DDE link to DDE server in Excel 2007 0
Excel Excel Linking to Access - Chart doesn't update 1
DDE link in Access 2003 3
Prevent Excel chart flicker,when plots are linked to DDE data 1
DDE automatic refresh 1

Back
Top