AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
Question I have created an application in vb.net which reads a textfile and loads the data into the access db. In access i have a table(Details) with 3 columns (NAV,Date,Rs).if my application reads the textfile more than once how do i prevent duplicates being created in Access DB.How should i go about it?
Thank you.
Answer For each row that you retrieve before inserting it into access you simply query access with the text file rows values to ensure the row doesnt already exists, if it does then skip it otherwise add to DB.
You can also create a unique fields in your access db so if a value is duplicated in that/those columns it will not allow entry.
