Welcome to SPN

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

Sign Up Now!

Append tables

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

Tags:
  1. maxaral

    maxaral
    Expand Collapse
    Guest

    I have an Access table linked to an external excel file that is updated
    frequently. Is there a way to have only the new entries on the external
    table appended to the Access table? (Using MS Office2003)

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Cold weather damages sugarcane, vegetables in Punjab (New Kerala) Breaking News Feb 1, 2008

  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello "maxaral".
    "maxaral" wrote:
    > I have an Access table linked to an external excel file that is
    > updated frequently. Is there a way to have only the new entries on the
    > external table appended to the Access table? (Using MS Office2003)


    What do you mean with "linked"?
    If you created a linked Excel table in your Access database there was
    nothing to append.
    So I guess you did not and you frequently add records through an import.
    To identify what you already have imported, there should exist a column
    containing unique values that can be used to identify the records.
    1. Proposal (quick and dirty):
    Make this column the primary key of the Access table.
    You will get an error message about a number of key violations on every
    subsequent import, but new records will be imported.
    2. Proposal (like it more)
    Create a linked table that points to the Excel file. Create a query that
    finds the records of the linked table that have no mathing record in the
    Access table (there is a wizard for that) and append these records to
    the Access table.

    --
    Regards,
    Wolfgang
     

Share This Page