PDA

View Full Version : Prevent Data Duplication on Update?



defcon_3
01-04-2012, 08:46 PM
Howdy guys. I have this little problem about data duplication in my database. Here is the scenario. I have a spreadsheet (eins) which I use for data entry and I created a database (bakup) to backup the data I have in my spreadsheet. The problem is that each time a run the Macro i created in my spreadsheet all the data will be copy in my database and it create duplicate depending on how many times you run the macro. I just want to backup the new data entry in spreadsheet not copy all the data again. Is there any Macro to prevent duplication in Access aside from builtin query?
Attached is the files i used.

Thanks much..