Post reply

Excel Connection string - Dynamic string

  • January 10, 2012 at 4:53 am

    #248817

    Hi All,

    when i am trying to give the connection string as dynamic for excel as below:

    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ @[User::FilePath] +";Extended Properties=\"" + "Excel 12.0;HDR=YES" + "\""+";"

    i am getting the error:

    please check the attached untitled.bmp

    🙂

  • January 11, 2012 at 1:57 pm

    #1432112

    Never seen that error. Did you try using the ExcelFilePath property instead of the ConnectionString property? And also setting DelayValidation to true?

  • January 11, 2012 at 2:14 pm

    #1432131

    And setting it as an Expression, not directly as a property.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply