Loading

data transfer from excel to oracle

amit_gupta14

Looking for a code that can transfer the data from excel to Oracle table.
e.g. in excel,
Id Name
1 a
2 b
Same structure i.e. Id, name fields are present in oracle table. We have to just transfer the excel data to that oracle table.
Note: We need to do it in connected mode (i.e. without using dataadapter etc)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
well my friend, if you didnt want this as an Online connection i would offer you to build a simple grid application and sync the data via dataadpter.

but if you are looking for an easy way to work via excel on Oracle, you need a bridge application
which will take you too long to build so i highly recommend you to use

http://www.oraxcel.com/

i am and its owsome