0

I couldn't find any solution to set a SQL query in Excel with a dynamic table name which is in one of the cells in the workbook. 

LEFT JOIN [param!$a$5] B ON B.LOGICALREF = H.ACCFICHEREF

param!a5 has the name of the table.

More info : i have several tables and the names of the tables differ construction site to site ( 91, 90 , 89 as "LG_086_EMUHACC" ) I want to execute the query for each site as i change the code of the site.

Umut K
  • 1,364
  • 12
  • 25
  • 2
    Y need to supply more info – HarveyFrench Aug 24 '15 at 13:53
  • Possibly helpful: http://www.ozgrid.com/forum/showthread.php?t=170045 – AHiggins Aug 24 '15 at 14:37
  • possible duplicate of [How to pass a column name value as SQL argument using placeholders](http://stackoverflow.com/questions/12537629/how-to-pass-a-column-name-value-as-sql-argument-using-placeholders) – AHiggins Aug 24 '15 at 14:38
  • More info : i have several tables and the names of the tables differ construction site to site ( 91, 90 , 89 as "LG_086_EMUHACC" ) I want to execute the query for each site as i change the code of the site. – Umut K Aug 24 '15 at 14:55

0 Answers0