loading...
We'll show you how to compare Access database tables:
Otherwise, it can be found "Start menu -> Settings -> Control Panel -> Administrative Tools -> ODBC data sources.
Here on BDE interface -> Databases tab and click right mouse button on the white area:
Now name is for example pelda1. With select button should browse the database and then OK button is pressed always.
Select the BDE SQL icon and write in alias field pelda1 in our case. This is optional of course, and if you have more database access, then you can create multiple alias too.
Underneath, on text field write the SQL text. The following SQL lists all data fields in table named "cikktorzs" and sorted by "product number". This sort is very important, because the comparison must be set the key fields! The key field means what we provide in orderliness.
Here we can see the field names, which should be matched with each other. If you do not see the fields properly, press the following icon:
Select this and add it "add fields Compare" named button.
If the source table the item missing the color is green. If the target table the item missing the color is yellow. And in this case the 'quantity' different, the color is red. All fields bring up the bottom. The "s_" signal means the source table fields, the "d_" sign means the target table fields, the "db_compstate" field indicates the status (missing or not equal).
This table can be exported, push over the table with right mouse button:
Good luck!