Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare Datasets and delete

Status
Not open for further replies.

dedo8816

Programmer
Oct 25, 2006
94
GB
Hi, not sure this question has been asked before but here goes

Every week I have to compare to lists of data in Excel, the data can be anywhere from 2000 lines to 5000 lines, it becomes tedious!

I had an idea for an app where I would have 2 datasets filled from a database where id have imported both lists.
I don't need to look at the lines that are the same, my interest lies with the differences, my idea was this.

Fill 2 datasets to compare, have the new data compare against the old, if the compare finds that the data is the same, it erases itself, if it is not the same it moves to the next record. This would leave me with only the information that was different. Does this make sense?

Id really appreciate some help as I don't know where to start after building the form and populating the lists. Its the compare code im going to struggle with.

Thank you all
 
You may be better off asking this question in here instead.

Since it is an Excel (probably VBA) question, and you are in VB.NET, different animal.

Have fun.

---- Andy
 
Yes but im hoping to build an app using VB.Net to do the job..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top