Import Charts and Data to Access

[Guest]

Hello
I have an excel sheet containing data and graphs(Charts) based on them. I
want these data and graphs to be imported to Access. Data must be linked
together with specific graph (chart). I dont mind if the graph (Chart) is
imported as image.
I want to have a combo box on the top of a form. When I select an option to
appear the data with the specific graph(chart).
How I can do that??
Is there any example similar on the internet to look at it??
Please help me!
Thanks in advance

 

[Bruno Campanini]

Hello
I have an excel sheet containing data and graphs(Charts) based on them. I
want these data and graphs to be imported to Access. Data must be linked
together with specific graph (chart). I dont mind if the graph (Chart) is
imported as image.
I want to have a combo box on the top of a form. When I select an option
to
appear the data with the specific graph(chart).
How I can do that??
Is there any example similar on the internet to look at it??
Please help me!
Thanks in advance

I think the best way to have all things fully updated is
to have in Access a table linked with a range in excel,
e.g.:
DoCmd.TransferSpreadsheet acLink, _
SpreadSheetType:=acSpreadsheetTypeExcel9, _
TableName:="LinkTab", _
FileName:="C:\Document\Excel\XLS\Statistica.xls",
_
HasFieldNames:=False, _
Range:="Trasposizione!O3653"

and the Chart created in Access based on that linked table.

Ciao
Bruno

 

[Guest]

Thanks but the Transferspreadsheet aclink works only for data import and not
for chart. How can I import a chart?? I dont know I put the range of chart
but nothing is imported. Maybe tha chart is a special case is not considered
as a range but as an object? How can I import a Chart to Access???

 

[Tim Williams]

You could use the chart's Export method to create a GIF or JPG of the plot
and then use ADO to insert the image into a BLOB column.

http://groups.google.com/group/micr...rt+image+stream&rnum=8&hl=en#60233228dfa53c4e


Alternatively, put the image in the filesystem and store the path to the
image in the database.

Tim.

 

[Bruno Campanini]

Thanks but the Transferspreadsheet aclink works only for data import and
not
for chart. How can I import a chart?? I dont know I put the range of chart
but nothing is imported. Maybe tha chart is a special case is not
considered
as a range but as an object? How can I import a Chart to Access???

You can't link an Excel chart to Access; you can export it (somebody
else explained how to). But, in this case, you have a table linked
(i.e. automatically updated) and a chart you must delete and re-import
every time you want it to be updated with the Excel one.

If you make a chart in Access (you can make the same type as
in Excel) based upon a linked tabele, you have both automatically
updated with Excel data.

Bruno