Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have module thet get the Permissions for user from SQL Tbl, i used with section access & section Application .
i have to convert my Sql tbl to Xls Tbl (load the tbl from xls) .
when i add the section access & section Application to the loadind from xls it's failed.
but if i commete it it's work fine but i must have this lines.
i copy my code:
from sql- work fine:
ODBC CONNECT TO SQL (XUserId is bbb, XPassword is yyy);
 Section Access;
  LOAD ACCESS,
      NTNAME,
     DEPT;
  SQL SELECT *
  FROM bbb.d.QlikviewSec;
 Section Application;
 LOAD DEPT,
    PATH;
 SQL SELECT *
FROM aaa.d.UserDept;
from Xls-not working:
SECTION Access;
LOAD [ACCESS], 
     NTNAME, 
     DEPT
FROM
C:\bbb.xls
(biff, embedded labels, table is sheet1);
SECTION Application;
LOAD DEPT, 
     PATH
FROM
C:\aaa.xls
(biff, embedded labels, table is sheet1)
 
tnx for healping!
 Peter_Cammaert
		
			Peter_Cammaert
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Still not fixed? I guess something else is wrong. Could you post your QVW, or at least a limited copy (with data) that still isn't working? That would make analysis a lot easier.
Luck,
Peter
