I have data in two different access databases that I want to compare within vb.net. Again, this is two different databases... not two different tables. Is there a way to compare a column from table "A" in database "A" to a column in table "B" in database "B"?
Thanks
Ryan

If I'm reading correctly then what you're interested in is comparing the contents of each database with each other. If so, then what you will need to do is extract whatever data is to be compared from each database, and then perform the comparisons. Can you elaborate on what it is you're trying to accomplish?

Sorry for not being all to specific before...

I have two access databases. One is filled with a list of data and the day on which we began to carry that data. However, there has been talk that some of our dates are incorrect. Because of this, I was sent a second database which carries similar data but with the correct starting date. There are far too many records for me to go through and check them one by one, so I want to compare them within .net to see where our records are incorrect. Both of these databases are automatically filled so I do not have the ability to write to them... only to read them.

Does that help?

Thanks

Extract the data from each table, and compare each value one by one. Whenever the value doesn't match, output the row number and the value from each table.

Thank you for your help!