UPDATE. I made some modifications in the program to allow to pass tcExcludeColumn. Took me some time to figure out I needed to use & in the gather / scatter fields except syntax. Now it works fine and I am able to process all the sheets.

Tomorrow I'm going to implement my idea of creating a table in SQL Server with the original vendors structure with triggers. Will see how it would work.

Thanks for introducing me to that program.

---------------------------------------------------------------------------------------------------------------------
I have a question.

My Excel worksheet contains field names in the first row like so

Full Name Contact Address 1 Address 2 City State Zip Email address Area Code Phone User Defined Check Box 1 User Defined Check Box 2

I have cursor created with correct structure.

I'm using the following command

llReturn = AppendFromXlsx(m.tcExcelFile, thisform.aWorkingSheets[m.lnI,2],,2, thisform.aWorkingSheets[m.lnI,1])

Do I understand correctly that I need to start from the second row or I should not pass 2 as a parameter?

The program fails on this line
GATHER FROM laFieldGat MEMO

and I see that laFieldGat is equals to the data from the first column (second row).

This command

SELECT (m.cCurSheet)
				APPEND BLANK
				SCATTER MEMO TO laFieldGat

when I examine laFieldGat in the debugger I see it being equal to the data in the row and not the array, which is weird. But may be the problem stems from the fact that I create a cursor with the extra Id column which should be ignored while populating the cursor. I haven't looked very closely into the code to see if the program allows to exclude certain columns in the cursor.