visual basic excel access
Posted on 2003-03-21
i have this: in access i hava a table that contains emails:
3 firstname.lastname@example.org and so...
well in excel i have something like that..
so i want to compare the access with the excel and make a report in excel like this
1 email@example.com already exist
2 firstname.lastname@example.org already exist
3 email@example.com new
so i want to take each cell of excel and compare it with the table in access, so if it is the same, i want to make another excel with the results that already exist, and if it doesn't match with anyone, put the result that is new.