2 Replies Latest reply: Dec 2, 2010 1:55 PM by vkomarov RSS

    Extracting the source data file name

    vkomarov

      Hi!

      I am loading some data from multiple Excel files using the following code:

      for i = 0 to 20

      CONCATENATE LOAD
      [Type],
      [Date],
      [Country],

      // XXXXXXX as [Source File Name]

      FROM
      [Data*.xls] (biff, embedded labels, table is data$);

      next

      I would need to set up the field ([Source File Name]) where I would be storing the name of the each source file for each record I am loading.

      Any suggestions will be greatly appreciated.

       

      Best regards,

      Vladimir