Insert into Oracle from Excel VBA

Question

Hi,

I'm using ADO object to connect oracle database. When I execute an INSERT statemnet from VBA it is getting inserted properly. If I check the same record with the current connection, I am able to retrieve the inserted data. But when I check the same directly in Oracle it is not reflecting that inserted Data.

For cross verification, I have created one more button to check whether the Data inserted into the ORACLE table. But there I'm getting only zero recrods.

(I have tried with connection method .BeginTrans and cn.CommitTrans before execute statement)

Can any one of you please let me know the reason.

Regards, Ram

Answer 1

This sounds like you are missing a COMMIT after your INSERT statement.

This article does a

objADO.CommitTrans

after executing the insert.