Forum Discussion

MarinaB's avatar
MarinaB
Occasional Contributor
8 years ago

How to set variable to read data from SQL select statement written in excel file?

In excel file in column named Account i have written the following SQL statement: 

"select top 1 account from TestTable (nolock)".

 

How can i set "account" value that SQL statement returns as variable?

 

  • shankar_r's avatar
    shankar_r
    Community Hero
    8 years ago

    Hi,

     

    Not sure what you are trying to achieve here. if you could give us some more information would be help to answer your question

     

    TestComplete provides DDT  driver option to get data from excel sheet.