Excel Data to Oracle

[Dan_C]

Hi,

I can upload data from excel to access having created stored procedure on access.
I do the upload using my vb 6.0 code.

How can I upload data from excel to oracle db? could i use the same technique as above? only problem is im not sure if that vb code will work with oracle?

has anyone done this before? anyone have example code?

kindly assist me here

thanks

 

[cjard]

just change the connection string to connect to your oracle instance and alter the SQL syntax if there are any parts that arent compatible (plenty of tutorials on how to run oracle SPROC from vb6)