title: Excel VBA Data Export
body: <p>Here is the code I have written to export data from access to excel but can not see any records.</p>
  
  <pre><code>Sub copyFromRecordset()
  
      Set conn = New ADODB.Connection
      Set wipData = New ADODB.Recordset
  
      conn.ConnectionString = conStr
      conn.Open
  
      With wipData
          .ActiveConnection = conn
          .Source = "WipBin"
          .LockType = adLockReadOnly
          .CursorType = adOpenForwardOnly
          .Open
      End With
  
      Worksheets.Add
      Range("A2").copyFromRecordset wipData
  
      wipData.Close
      conn.Close
  
  End Sub
  </code></pre>
  
  <p>please advice</p>