4 Replies Latest reply: Jul 6, 2011 6:53 AM by lavvyvkt RSS

    Select ... where field in (csv or txt file)

    Dirk Mathias

      Hello,

       

      i load values from a csv or txt file.

       

      these values are used as a filter to load data from sql server

       

      example:

       

      Table1:

      LOAD

      KVNr,     

      FROM

      H:\Test_Filter.xls

      (biff, embedded labels, table is Sheet1$);

       

      Table2:

      SQL SELECT *

      FROM "MiamiCRM".dbo.Mitglieder where KVNr in(Table1);

       

      how can i do this ?