Databases comparison  
Author Message
gil bil

PostPosted: Visual Basic for Applications (VBA), Databases comparison Top


i have a big database where i store a lot of data.

in order to make sure that there are no mistakes in the data (usually becasue of typing mistakes) i type the same data to 2 different folders.

no i have 2 files that supposed to be equal.

how can i compare the 2 database to ensure that they contain the same data

is there any build-in function that compare 2 databases i want all the mismatches to be stored in a table:

Table, Field Name, First Value, Second Value

Microsoft ISV Community Center Forums2