Read from excel data and insert into oracle Db using VBA

[discusmania]

Hi guys...

This is the first time i try to code in VBA in Excel. I need to know is there any sample code that read data from MS sperad sheet and input it to oracle database.

I'm new here , your help is very much appreciated

Regards
Ron

 

[TCARPENTER]

Hi Ron,

You may not find anything specifically from Excel to Oracle but check the ADO documentation, that should get you going.

HTH
Todd

 

[PHV]

Another interesting site:

http://www.connectionstrings.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886