Consulting

Results 1 to 5 of 5

Thread: SAS-VBA connection

  1. #1
    VBAX Regular
    Joined
    Feb 2016
    Posts
    17
    Location

    SAS-VBA connection

    Hi guys,

    I am trying to set connection for VBA with SAS, can anyone help me please understand where to get
    the server name and data source from in the below statement? is "sas.LocalProvider" standard statement that i can use as it is or do i need to change it and use my own provider name? if so where to get it from? also the Data Source folder is within SAS software I believe in the Libraries isn't it? so what to write?

    obConnection.Provider = "sas.LocalProvider.1"
    obConnection.Properties("Data Source") = "folder containing SAS tables"
    obConnection.Open



    Regards,

    Samo
    Last edited by SamT; 03-22-2016 at 11:40 AM.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Bump
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    Moderator VBAX Master Tommy's Avatar
    Joined
    May 2004
    Location
    Houston, TX
    Posts
    1,184
    Location
    https://support.sas.com/documentatio...t/odbcdref.pdf
    The link will take you to the ODBC reference for SAS.

    If you need help with what the document says let us know.

  4. #4
    VBAX Regular
    Joined
    Feb 2016
    Posts
    17
    Location
    Thanks a lot, i will check the link and see if it is helpful.

    Samo

  5. #5
    VBAX Regular
    Joined
    Feb 2016
    Posts
    17
    Location
    Hi Tommy,

    I am not sure this has anything to do with accessing SAS from VBA in excel, I just wanted to know the Provider and Data Source as in my questions above, any suggestions?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •