Import Charts and Data to Access
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
|