HELP: Comparing data code

[claudz_08]

I have two tables containing email addresses. ONe is the master table and the slave table.

I need a VBA CODE that will compare these two tables and will automatically delete email addresses in the slave table that are already in the master table. And an output table will show ,after comparing,containing the addresses in the slave table that is not present in the master table.

PLease please i need help...i'm just a beginner on this. thanks

 

[Mile-O]

Why use VBA Code? A query can do this for you.

Fix the field names to your database where Info in each table is the field you wish to check for duplicates...

DELETE DISTINCTROW tblSlave.SlaveID, tblSlave.Info, tblMaster.Info
FROM tblSlave LEFT JOIN tblMaster ON tblSlave.Info = tblMaster.Info
WHERE (((tblMaster.Info) Is Not Null));

Save your query then, using VBA code, run the query.

With DoCmd
    .SetWarnings False
    .OpenQuery "qryYourQuery"
    .SetWarnings True
End With

Now, you can simply display the Slave table as all of these records won't have a duplicate email address in the Master table.

 

[claudz_08]

Yah i know that it can be done through query. But what i'm going to do is an automation that will compare data and auto-delete email addresses. because what i really need to do is get these new email addrsses from the outlook express address book then autocompare and autodelete duplicate addrsses. And that i dont know how m i gonna do that using vba codes.

 

[Shadez]

I could do it very easily with outlook or lotus notes, but i dont know how to get the address list out of outlook express.

If you can find this out i sould be able to help you.


ShadeZ

 

[claudz_08]

In order to extract the email addresses from outlook express address book you need to go to file menu then-other address book , Then save it as .csv file. And you can open this .csv file in ms excel then import it to ms access.

 

[Shadez]

I thought you ment using vba in access to extract the addresses from outlook express on the fly.


Do you need to proccess the CSV directly or are you importing the file first.?