Hi Access Experts out there
I have trawled this site to try and resolve my query challenge and given my inexperience in Access (2010) I cannot fathom how to resolve my problem. I have summarised what I am trying to achieve below:
I have created a linked Excel table in Access 2010 called 'tblExcelLinked' and I have a form called 'ASB Log Form' for the purposes of presenting the data in a more readable manner that is easier to view, plus link other fields of data that are not directly related to the 'tblExcelLinked'.
Because there is no unique ID in the 'tblExcelLinked' to create a relationship, I have created a table called 'tblASB', which allows me to add other table data linked from same d/b.
I now want to update the 'tblASB' with data from the 'tblExcelLinked', but only append new records from 'tblExcelLinked', but my inadequate append query is duplicating the records each time I run it, rather than just adding the new ones.
Thanks if anyone is able to assist.
Regards
Steve
Once sorted my next challenge is a macro so that this runs automatically rather than being manually triggered.
I have trawled this site to try and resolve my query challenge and given my inexperience in Access (2010) I cannot fathom how to resolve my problem. I have summarised what I am trying to achieve below:
I have created a linked Excel table in Access 2010 called 'tblExcelLinked' and I have a form called 'ASB Log Form' for the purposes of presenting the data in a more readable manner that is easier to view, plus link other fields of data that are not directly related to the 'tblExcelLinked'.
Because there is no unique ID in the 'tblExcelLinked' to create a relationship, I have created a table called 'tblASB', which allows me to add other table data linked from same d/b.
I now want to update the 'tblASB' with data from the 'tblExcelLinked', but only append new records from 'tblExcelLinked', but my inadequate append query is duplicating the records each time I run it, rather than just adding the new ones.
Thanks if anyone is able to assist.
Regards
Steve
Once sorted my next challenge is a macro so that this runs automatically rather than being manually triggered.
Append Query - Unique Records
