store Excel Chart in Access

[pigworm]

HI!
I have many charts in excel. I want to store each of those charts as one row of data in Access database. besides, cut and paste, what can do with VBA? thanks for anyone's kind tips!! [sig][/sig]

 

[MichaelRed]

You do mean you want to store the data for the charts, don't you?

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[pigworm]

No! I mean I want to store every chart as OLE Object in each different row. For example, I have 800 chrats. and I want to browse them one by one in Access. that is 800 rows in Access Table.

 

[MichaelRed]

Well, this is a bit far out for me. I am not sure the Excel Sheets expose the chart object(s). Assuming that they do, you need a process to access each Excel workbook as an object, identify the Chart object(s) in the workbooks, add a record to your database, and finally link/embed the chart object in the databse.

Even if Excel does expose the chart as an object, It may not be able to export the chart with the data attributes necessary for Ms. Access to "display' the chart in it's original configuration (e.g. image).

As far as I know, Excel uses the same applet to generate the chart as Ms. Access (and Word ...). IN Ms. Access, the chart cannot be seperated from the datasource w/o "destroying" the image (this is why you cannot get an Ms. Access Report w/ a "graph" to retain the graph if you send it through e-mail).

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over