address validation automation

[ashok0141]

Hi Team,

i need to validation the zip code, locality name and state.

currently i am keying the data and validating manually with address data base available in excel

while validating i am following bellow procedure...

1st Priority is ZIP
if zip code found then search for locality name and state name, wheather available with give zip code or not and mention the result(Valid/Invalid)
output eg:- ZIP= Valid, Locality=Valid, State Valid

2nd priority is Locality:-
if zip code not found then mention ZIP="Invalid"
if locality name found then search for state name availabe with locality
output eg:- ZIP= Invalid, Locality=Valid, State Valid

3rd Priority is State:-
look for state name only
output eg:= ZIP= Invalid, Locality=Invalid, State Valid




regards,
Ashok

 

[ashok0141]

please also advice, how can i attach the excel sheet which have address data base and output

 

[Joe4]

You posted this question in the Microsoft Access question, but mention Excel in your question. Does Microsoft Access have anything to do with this question?

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.