Update Oracle vithe acess data

I can open an oracle table with this code

    Dim td As TableDef
    Dim db As Database
    Dim rs As Recordset

    Dim str_cnt As String

    'On Error GoTo fail

    Set db = CurrentDb

    str_cnt = "ODBC;DSN=NCY3;DBQ=ncy3.world;DATABASE="

    Set td = db.CreateTableDef("_PERSON") ' td.Attributes = dbAttachedODBC

    td.Connect = str_cnt
    td.SourceTableName = "P_PERSON"

    db.TableDefs.Append td

fin:

    Exit Sub
fail:

    MsgBox "Error: " & Str(Err) & "-" & Error$ & " Dans le module d'attachement"

    GoTo fin:

I want to update the oracle 7 with the access95 data

If you have some ideas

HANSS Eric
French Oracle Newbie Received on Mon May 03 1999 - 12:19:07 CEST