Use Excel value in VB Query


I have stored an employee ID in an excel file. Want to use the same value in a query.

Can you please help us with the syntax?


You are passing query in which activity

Execute DB query activity i am using. in the query i need to pass employee ID, the same i have stored in an excel.


  1. Use an Excel loop to map the Excel columns with arguments.
  2. Using an Assign activity , create a query with input argument=argument defined in the Excel loop.
  3. Use ExecuteDBQuery activity with query=as defined in Step 2.