PC Review


Reply
Thread Tools Rate Thread

Auto Delete imported duplicate records

 
 
BTU_needs_assistance_43
Guest
Posts: n/a
 
      22nd Jul 2009
I've been searching and found a number of ways to manually delete duplicates
at any given time, but the way my code records data so frequently I would
like to be able to have it automatically detect and delete any records its
importing that have already been imported OR to just not import the records
that are duplicates. My program imports excel files according to recently
added files because some files I've already imported may get updated with
more recent data added onto the already existing data. How can I make my
program detect or check that the file I'm uploading has been imported before
and not import or record duplicate data?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row EagleOne@discussions.microsoft.com Microsoft Excel Programming 6 20th Aug 2009 02:40 AM
Delete records when certain records have duplicate column data JVroom Microsoft Excel New Users 0 26th Jan 2009 05:07 PM
Duplicate many records with auto save =?Utf-8?B?amVoYWQgaGluZGk=?= Microsoft Access 1 28th May 2007 11:04 AM
duplicate records and auto number Swathi Microsoft Access Forms 1 22nd Jul 2005 07:31 PM
Auto Duplicate of Records Daniel Microsoft Access Queries 2 9th Apr 2004 04:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 PM.