View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default extract data from sqlplus into excel sheet

These might give you a start:
http://www.experts-exchange.com/Prog..._21751278.html
http://msdn.microsoft.com/en-us/library/ms524771.aspx

In the Excel VB Editor add a reference to "Microsoft ActiveX Data
Objects...." (whichever version is on your machine)

Tim


"StevenM" wrote in message
...
I want to be able to run an sqlplus query and take the rows that come back
and put them in some specified spot in the current worksheet. I have
absolutely no idea how to either make the call to sql or how to handle the
returned rows. I would appreciate someone pointing me to somewhere so I
can
read and take a shot at doing it. Any suggestions or directions to do
this
would be very gratefully received. Thanks in advance,
StevenM