Exporting data from Excel to Oracle

[decci_7]

Hi,

I have developed one macro which will fetch the data from excel sheet and will upload it to the oracle tables.

Sub enterdata()

'Create and set login information variables


'Set Variables for Upload
Dim empid As String
Dim name As String
Dim role As String

'Create and Set Session / Create Dynaset = Column Names
Dim Session As Object
Set Session = CreateObject("OracleInProcServer.XOraSession")
Dim OraDatabase As Object
Set OraDatabase = Session.OpenDatabase("decci.7.in.abc.net", "user/password", 0&)
Dim Oradynaset As Object
Set Oradynaset = OraDatabase.DBCreateDynaset("SELECT * FROM security1", 0&)
    
Range("A2").Select
    Do Until Selection.Value = ""
        empid = Selection.Value
        name = Selection.Offset(0, 1).Value
        role = Selection.Offset(0, 2).Value
        Oradynaset.AddNew
        Oradynaset.fields("empid").Value = empid
        Oradynaset.fields("name").Value = name
        Oradynaset.fields("role").Value = role
        Oradynaset.Update
        Selection.Offset(1, 0).Select
    Loop
End Sub

The data uploading is done as required. But now i have an additional requirement. I want to check in the table before entering whether the employee id i'm entering already exists in the table. If it does then i want to overwrite that record with the latest one from the excel sheet. Does anyone know how to accomplish that?