Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
FileList:
LOAD * INLINE [
FileName, TableName
REGION.XLS, REGION$
DIVISION.XLS, DIVISION$
];
FOR i = 0 TO NoOfRows('FileList') - 1
LET FileName = peek('FileName', i, 'FileList');
LET TableName = peek('TableName', i, 'FileList');
div_reg_table:
LOAD
*
FROM '$(FileName)'
(biff, embedded labels, table is '$(TableName)');
NEXT
Hi, is this a question or hint? If it fails it migh be because if the excel is in another folder of the QVW it will need the path for the excel.