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

"Kyriaki" wrote in message
...
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!O36:P53"

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

Ciao
Bruno

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???

"Bruno Campanini" wrote:

"Kyriaki" wrote in message
...
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!O36:P53"

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

Ciao
Bruno

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/micro...233228dfa53c4e


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

Tim.


"Kyriaki" wrote in message
...
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???

"Bruno Campanini" wrote:

"Kyriaki" wrote in message
...
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!O36:P53"

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

Ciao
Bruno

"Kyriaki" wrote in message
...
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












"Bruno Campanini" wrote:

"Kyriaki" wrote in message
...
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!O36:P53"

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

Ciao
Bruno