Use Excel value in VB Query

Automation Studio
1

Hi,

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?

2

Hi,

You are passing query in which activity

3

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

4

Hi,

  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.

Thanks.