Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Question Unanswered: Import Excel into Access

    i know that i can import the data that i have in my excel sheet into access and it will only import the records that aren't already there by using indexing on one of my fields.

    However, i want to be able to sync the excel file and a table in my database, so that all records that are not in my database will be added, and those records in my databse that are not in excel will be deleted.

    i hope i was clear in what i was trying to do. Any Ideas????

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Will need to create a Query the create a Join That Shows all records from one Side Which Then create a Blank Records(Null value on the other side)
    Then only show all null records Bla you have got Missing records Showing

    eg

    Table1
    1id text1
    1 bla
    2 bla1
    3 bla2
    4 bla3
    5 bla4

    Table2
    2id text2
    1 blabla
    4 blabla
    5 blabla

    When you join the above 2 table by the 1id=>2id and set the join type
    so it show all records form table1 and those records in table 2

    record 2 and 3 will have a blank(null) text2

    then only showing the nul value Will show what reocrds are missing from table2 that should be in table1
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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