Difference between Connection strings syntax for OLEDB Connection (Worksheet Connection) and Model OLEDB Connection (External Connection for Data Model) in VBA RRS feed

  • Question

  • Please help me to find out difference between connection strings syntax in VBA for OLEDB Query and Model OLEDB Query (used for Data Models)?
    I tried figuring out by recording Macro for Data Model connection but it generates the same connection string what I generally use for my normal OLEDB Connection (Worksheet Connections).
    Tuesday, July 26, 2016 1:27 PM


  • Hi Sarang  Agre,

    please visit the link below. to get information regarding connection string.

    Connection String Syntax

    Tabular Model Data Access



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Sarang Agre Wednesday, July 27, 2016 8:32 AM
    Wednesday, July 27, 2016 6:30 AM