How to use Table variable into SQL query instead of sheetname

Question

Example is -- select * from [Sheet1$$]; I want to use Table Variable instead of Sheet1I tried to using ---   select * from [Table variable$$]; It is not working , can anyone suggest solution

Raul Jaimes · Answer

@ap442Declare a new variable which will contains the sheet name and use it into the select query as belowHTHRegards

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded