Results 1 to 2 of 2
  1. #1
    izzarshah is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    1

    Linking Access Table with already imported External Data (Excel)

    Hi everyone,



    I would like to know how could i link an Access Table with the table that has been importeed from Excel in Access.

    The Excel data has been imported into Access. So right now i would like to make a new Access Table so that i could link both of them.

    The Excel table will get new data and will be refreshed in Access.

    Could anyone give me a solution please. It's very important for my thesis.

    Thank you.

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    Quoted from this article,
    http://www.vb123.com/toolshed/98docs/excelbe.htm

    As of October 2005, an automatic upgrade for Access 2002 and 2003 made changes to Excel through linked tables impossible. If you rely on this technology, your databases will fail when your users install this upgrade.
    http://support.microsoft.com/kb/904953/

    So, there is no way now to use access to update excel.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 30
    Last Post: 06-26-2011, 10:47 PM
  2. populate table w/ external data
    By tlittell in forum Programming
    Replies: 2
    Last Post: 02-20-2010, 08:29 AM
  3. Error Linking External Table
    By mcgowan.b in forum Import/Export Data
    Replies: 9
    Last Post: 11-24-2009, 07:44 AM
  4. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  5. Call Excel Data into Access table
    By jiguvaidya in forum Import/Export Data
    Replies: 0
    Last Post: 09-15-2008, 04:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums