3 Replies Latest reply: Dec 2, 2014 5:24 PM by BAIKANG CHEN RSS

    Automatic Table Name when using * in reload script

    BAIKANG CHEN

      Hi:

       

      I was trying to load some excel file with part of the name are the same with each other.

       

      So I use the wildcard * like follow:

       

      Table:

      LOAD

           [Field Name]...

      FROM

      [File Path\FileName*.xls]

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

       

      The first excel file load in OK with the name Table as assigned.

       

      But he rest of the excel load in a table with the name 'Table-1'.

       

      How can I make all excel files load in to the same table with the name 'Table' ?

       

      Thank you very much.

       

      PC