• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Automation  > Send Access Data to Excel and Create an Excel Chart

12.6. Send Access Data to Excel and Create an Excel Chart

12.6.1. Problem

You want to export data from Access to Excel and create a chart programmatically.

12.6.2. Solution

You can use an ADO Recordset object to export data to Excel programmatically, then use Automation with Excel to create a chart based on the exported data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint