Trouble with creating new from xls - execution of script failed

[#1]

Ok - I have been trying lots of options - reduced the data set, filtered out and replaced characters that might create issues.  Can someone help - or point me to some help materials on creation issues from a xls data set?  Size limitations - rows, characters, columns - character issues - like - do I have to remove all "&".  I have tried these types of things and the create new still is failing with the same error. 

Please help - thanks!

[alexandros17]

Can you post xls?

[#3]

Yes – but I have to mask some of it first.

[#4]

I couldn’t see how to upload the xls – so here is the file – in a condensed and masked version.

Thanks, David

[#5]

Here is the script that failed:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD ,

,

,

,

Type,

SLT,

,

,

,

,

FROM

(ooxml, embedded labels);

[alexandros17]

I had no problem .... se the attachment modified!

[#7]

So - what did you have to change? And if not anything - what do you suggest I do to resolve?

[#8]

Ok – I had someone look at this for me and the quickly figured it out – two columns with the same name – simple error – should have caught this.