2 Replies Latest reply: Mar 15, 2012 9:44 AM by Geoff Hunter RSS

    Load from Excel file with embedded labels containing multiple lines

      I'm trying to produce a script to load from an Excel file with embedded labels containing multiple lines, e.g. attached file.

       

      The script produced by Table Files button includes carriage return characters within the field name, e.g.

       

      LOAD [Column

      Heading]

      FROM

      Book1.xlsx

      (ooxml, embedded labels, table is Sheet1)

       

      and fails to find the field when I load, e.g.

       

      Field not found - <Column

      Heading>

      LOAD [Column

      Heading]

      FROM

      Book1.xlsx

      (ooxml, embedded labels, table is Sheet1)

       

      Does anyone know of a workaround that doesn't involve editing the source data file?

       

      Thanks