Hi Team,
I am trying to upload excel file but getting below error.
SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
My operating system is 64 bit
Currently I am using below code:-
Let vDir = '$(vPathCSP)' & '*.xlsx';
FOR Each file in FileList(vDir)
ODBC CONNECT32 TO [MS Excel;DBQ=$(file)];
tables:
SQLtables;
DISCONNECT;
NEXT
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
LET file_path = purgeChar(purgeChar(peek('TABLE_CAT', i, 'tables'), chr(39)), chr(36));
IF sheetName='Sheet1' THEN
Employees:
LOAD Distinct //Added distinct since the belgium dummy data is not unique, it is made from the training data
'1' AS IND_EMPLOYEE_DATA,
[Pers.nr.] AS EMPLOYEE_ID,
// ID is required for export functionality
[Pers.nr.] AS ID,
[Practice] AS PRACTICE_CODE,
//[EG],
[Aanspreeknaam] AS EMPLOYEE_NAME,
[Emailadres] as Emailadres
FROM $(file_path) (ooxml, embedded labels, table is [$(sheetName)]) where IsNum([Pers.nr.]) AND [EG] = 'CSS-P' AND
match([Practice],'B19','B50','B51','B60','B61','B70','B71','B42') > 0; //Added the BE Gxx practices
// FROM $(file_path) (ooxml, embedded labels, table is [$(sheetName)]) where IsNum([Pers.nr.]) AND [EG] = 'CSS-P' AND
// match([Practice],'B19','B50','B51','B60','B61','B70','B71') > 0; //Added the BE Gxx practices
ENDIF
NEXT
Regards,
Chinmay Utekar
