11 Replies Latest reply: Aug 28, 2015 12:19 PM by Simon TENTILLIER RSS

    Script use Excel List to SQL resquest

      Hello,

       

      I don't if it's possible...

       

      I have an Excel file like this :

           Num_Customer
           0123
           5156
           9656

           ...

       

      1. I want load this file in my script  --> OK

      (using : LOAD Num_Customer FROM [path:excel_file.xls] (biff, embedded labels, table is feuil1$);

       

      2. Use it in SQL request like : --> KO

      Name_TABLE : SELECT * FROM SQL_table_Name WHERE Customer IN ( MY_CUSTOMER_IN_EXCEL_LIST)

       

      I know it's possible to use 'Entry field' (using : '0123', '5156','9656')


      Somebody to help ?? Thanks.