Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have qv10 rr4 and have no problems loading from your Excel file.
I have qv10 rr4 and have no problems loading from your Excel file.
I have QV10 SR1. Guess I need to upgrade again. Thanks, Geoff