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????
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
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
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.