Forum Discussion

MarinaB's avatar
MarinaB
Occasional Contributor
7 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 var...