View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Excel VBA against Oracle

Excel can also attach to the Oracle database using SQL.

Try the menu Data, Get External Data and New Database Query.

--
Richard


"Johnson Shine" wrote:

Hi, Would anyone help me answer this question? Can Excel VBA get data in
Oracle DB server? How can we do that? As I know, Excel VBA code is always
only able to get real-data which is from Access DB. Would appreciate it very
much!