Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Update Oracle vithe acess data
Hello,
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 - 05:19:07 CDT