+ Reply to Thread
Results 1 to 5 of 5

Import Charts and Data to Access

  1. #1
    Kyriaki
    Guest

    Import Charts and Data to Access

    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

  2. #2
    Bruno Campanini
    Guest

    Re: Import Charts and Data to Access

    "Kyriaki" <someone@hotmail.com> wrote in message
    news:369F5151-6487-47DF-BB93-EA5FF8076583@microsoft.com...
    > 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



  3. #3
    Kyriaki
    Guest

    Re: 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" <someone@hotmail.com> wrote in message
    > news:369F5151-6487-47DF-BB93-EA5FF8076583@microsoft.com...
    > > 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
    >
    >
    >


  4. #4
    Tim Williams
    Guest

    Re: Import Charts and Data to Access

    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" <someone@hotmail.com> wrote in message
    news:E3AE035C-35FA-47DC-BE76-0E7F94D2B0D5@microsoft.com...
    > 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" <someone@hotmail.com> wrote in message
    >> news:369F5151-6487-47DF-BB93-EA5FF8076583@microsoft.com...
    >> > 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
    >>
    >>
    >>




  5. #5
    Bruno Campanini
    Guest

    Re: Import Charts and Data to Access

    "Kyriaki" <someone@hotmail.com> wrote in message
    news:E3AE035C-35FA-47DC-BE76-0E7F94D2B0D5@microsoft.com...
    > 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" <someone@hotmail.com> wrote in message
    >> news:369F5151-6487-47DF-BB93-EA5FF8076583@microsoft.com...
    >> > 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
    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1