Import Charts and Data to Access

[Kyriaki]

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]

"Kyriaki" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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


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

Tim.


"Kyriaki" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>

[Bruno Campanini]

"Kyriaki" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>