How can I export a chart from Excel to Access??
 

Hello
How can I export an excel chart to Access??

Thanks a lot

How can I export a chart from Excel to Access??
 

hi Kyriaki

Excel chart can be exported as a image file(GIF or JPG format)
I can't understand what you asked

following is an example:
----------------------------------------------------------------------------
Sub Create_GIF()
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export FileName:="c:\Mychart.gif", FilterName:="GIF"
End Sub
----------------------------------------------------------------------------

How can I export a chart from Excel to Access??
 

I want to export an excel chart to Microsoft Access. I ask if I can export
the excel Chart to Microsoft Access in a table or in a form. Is there any
possibility?

" wrote:

hi Kyriaki

Excel chart can be exported as a image file(GIF or JPG format)
I can't understand what you asked

following is an example:
----------------------------------------------------------------------------
Sub Create_GIF()
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export FileName:="c:\Mychart.gif", FilterName:="GIF"
End Sub
----------------------------------------------------------------------------

How can I export a chart from Excel to Access??
 

if field data type is OLE object, the field restore binary data.
an exported chart image file can restored the field.
If you want to display a chart on the access form,
you'd better use active-x chart control(eg,Microsoft Chart Control or
the third party controls)