title: How do I connect to Oracle SQL using VBA?
body: <p>I'm a newbie with vba, and would appreciate help with connecting to Oracle SQL using VBA.
  I have such code for MS Server, and need to modify it somehow (or create a new one) so it works with Oracle SQL.</p>
  
  <p>Here's the code:</p>
  
  <pre><code>Public Const sConnect As String = "xxx; Initial Catalog=xxx; User ID=xxx;Password=xxx;"
  
  Sub GetData1()
  
  Sheets(1).Range("a1:ao20000").ClearContents
  
  Dim rsConnection As ADODB.Connection
  Dim rsRecordset As ADODB.Recordset
  Dim sQuerry As String
  
  sQuerry = "select * from xxx"
  
  Set rsConnection = New ADODB.Connection
  Set rsRecordset = New ADODB.Recordset
  
  rsConnection.ConnectionString = sConnect
  rsConnection.Open
  
  Set rsRecordset = rsConnection.Execute(sQuerry)
  
  Worksheets(1).Range("A2").CopyFromRecordset rsRecordset
  
  rsConnection.Close
  
  Set rsConnection = Nothing
  Set rsRecordset = Nothing
  
  End Sub
  </code></pre>
  
  <p>My questions are:
  Do i need to install anything else than Oracle Developer? If so, what?
  How to change the code to make it work?</p>
  
  <p>Thanks a lot in advance!!
  Regards,
  Maciej</p>