0

Hi friends,

I m creating a software with backend of ORACLE 9i.
I need to Generate backup ORACLE "ADDFILDP" table to ACCESS "ADDFILDP" table(Simply Copy the data to one table to another[ORACLE to ACCESS Table]):$
An access File is already Created.

I was code for it as Follows

Private Sub Command1_Click()
If ors.State = 1 Then ors.Close
ors.Open "SELECT * FROM ADDFILDP", ocon, adOpenDynamic, adLockPessimistic
While ors.EOF
 ars.AddNew
 ars.Fields(0).Value = ors.Fields(0).Value
 ars.UpdateBatch adAffectGroup
' acon.Execute "INSERT INTO addfildp values('" & ors.Fields(0).Value & "'"
Wend
MsgBox "Record Successfully Backupd...", vbInformation
End Sub

But it doesn't work. :'( There is no error generated by this code also.
:S
Can you send me the code to copy ORACLE 9i TABLE DATA to ACCESS Database Table?

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by hell_tej
0

Try using this

con.begintrans  'con--adodb connection obejct
con.execute "insert statment of data selected from oracle database"
con.committrans
0

Thanks for Reply,
Which connection (Access or Oracle) used in insert Statement
i want to copy all data into my access database from oracle 9i database:-O

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.