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

[MarinaB]

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]

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.