Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Linking table data to other MS apps

Discussion in 'Information Technology' started by Access Joe, Jul 28, 2006.

  1. Access Joe

    Access Joe
    Expand Collapse
    Guest

    Hi all,

    Is it possible to take data from an Access 2003 Table and place it into a
    Word / PowerPoint document as a 'Paste Link", so it updates automatically? I
    know this can be done with Excel, but I can't find a way with other apps.

    I apprecioate everyone help!
    Joe
     
  2. Loading...


  3. Maransreth

    Maransreth
    Expand Collapse
    Guest

    In Excel there is a way that you get an Excel spreadsheet to get the
    latest information from an Access table or query.

    I dont see why you then couldnt use the copy/paste link option from
    excel to another program.

    To do this, if you are unaware of it, is in Excel:
    Data menu>Import External Data (or Get External Data depending on your
    version)>New Database query.
    Choose Access from the list of databases, browse to where the database
    is found, choose the table or query, follow the other couple of
    screens that are not that important, then decide where in the Excel
    spreadsheet you want the data.

    The External Data toolbar should then come up, and you need to use the
    middle red exclamation mark to refresh the data, unless you want to
    refresh on open or refresh every x minutes from the properties.

    <AccessJoe@discussions.microsoft.com> wrote:

    >Hi all,
    >
    >Is it possible to take data from an Access 2003 Table and place it into a
    >Word / PowerPoint document as a 'Paste Link", so it updates automatically? I
    >know this can be done with Excel, but I can't find a way with other apps.
    >
    >I apprecioate everyone help!
    >Joe



    If you wish to email me, use my user name at optushome in Australia
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page