User Profile

Collapse

Profile Sidebar

Collapse
thekind78
thekind78
Last Activity: Feb 5 '08, 06:54 PM
Joined: Aug 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • thekind78
    replied to accessing a SQL View from VBA
    in Visual Basic
    Here is what I'm trying to do in VBA:

    query = "Select * from h8888.MaxRate"

    Set ado_conn = New ADODB.Connectio n
    ado_conn.Connec tionString = "ODBC;DRIVER=SQ L Server;" & "DSN=" & dsn & ";" & Db & ";" & uid
    ado_conn.Open
    Set ado_rs = New ADODB.Recordset


    Set xlSht = ThisWorkbook.Sh eets("Rawdata")...
    See more | Go to post

      Leave a comment:

    • thekind78
      started a topic accessing a SQL View from VBA
      in Visual Basic

      accessing a SQL View from VBA

      Hello,
      I am trying to access the results of a sql view from VBA. When trying to query the results of the view through VBA I get a "Object not found" error. I'm able to query tables, but have difficulty accessing views. Not well versed in SQL but I understand that Views seem to be virtual tables, however I am not sure why I am unable to query. Any suggestions much appreciated. Thanks in advance.
      See more | Go to post
      No activity results to display
      Show More
      Working...