i decided to make program, which will correct addresses in access file or some DB. Is not importent.
But there is main question whic way to chose? Is this just complicated sql, or is this some nice tool written in VBA,VB,java,...?
Requirments are big:
Number of data is above 100.000 rows. I have two tables, one is with wrong addresses and other has all possible addresses in our country. So this program, should correct addresses regarding right second table..
Anny suggestions? Only language I know is SQL and something VB.
Are there any visul programing methods, which will simplify this logic programing?