Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It does this for IE and for Chrome. Any help is appreciated!
Section Access;
Load
Upper(SERIAL) as SERIAL,
Upper(ACCESS) as ACCESS,
Upper(NTNAME) as NTNAME,
//Upper(PASSWORD) as PASSWORD,
Upper(COMPANY) as COMPANY,
Upper(SHEET) as SHEET
FROM "…..xls" (biff, embedded labels, table is [Security$])
WHERE COMPANY = '$(BusinessUnitLimit)' OR Upper(COMPANY) = 'ALL';
Section Application;
OrderTypeLimit:
Load
[Order Type],
Upper(ORDERTYPELIMIT) as ORDERTYPELIMIT
FROM "…xls" (biff, embedded labels, table is [Order Type Limit$])
WHERE EXISTS([Order Type]);
SheetSecurity:
Load DISTINCT
SHEET,
SHEET as Sheet
FROM "…xls" (biff, embedded labels, table is [Security$]);
Thank you!
Neena, if the video was helpful or answered your question, please mark that reply with helpful / answered so that others may benefit from your questions.
Thanks,
Jeff G