Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Importing vs. Linking


    If I import a table from one database to another will does the updates transfer over to the imported table?

  2. #2
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    I'm not sure what you mean by the updates. The easiest way to look at the difference between linking and importing is that linking is the actual live data whereas importing is static data, so if you perform a change on the table in the external database then the information will not be updated on the table that you imported into the other database.

    Dan H
    Access Database Developer


  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    try to understand the difference between importing and linking tables:

    Linking Tables: it is basically like creating a short cut of a file. e.g you have a File sam1.doc in your documents. if you create a shortcut of the same on your desktop and open the file using the shortcut and enter data, the changes are saved in the File sam1.doc and the shortcut basically connects you to that file. so a linked table is basically a shortcut of the original table in another database. it changes made to it will update the original table located in the other database.

    importing: its like coping the file sam1.doc from your documents to your desktop. now if you open sam1.doc on your desktop and make changes the changes are saved in the file that is on your desktop and in the File in your documents.

    now updating data: it seems that you have two databases in two different locations one with recent updates and the other may not updated. you can do the following:

    if your tables in this two databases are similar delete the tables in the database which is not updated and link the tables from the updated database into it.

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

Similar Threads

  1. Linking Tables?
    By briancb2004 in forum Access
    Replies: 0
    Last Post: 09-29-2008, 01:14 PM
  2. Linking Records
    By timryder in forum Access
    Replies: 6
    Last Post: 09-08-2008, 04:00 PM
  3. Resource for using linking tables with forms?
    By narayanis in forum Forms
    Replies: 5
    Last Post: 05-18-2008, 04:11 PM
  4. Linking Multiple records
    By rricci@marcct.org in forum Programming
    Replies: 0
    Last Post: 02-14-2008, 09:18 AM
  5. Linking tables and forms
    By vgatell in forum Access
    Replies: 0
    Last Post: 02-10-2007, 01:37 PM

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