Implemented using ODBC but facing some issue and so trying for any other alternative option.
**Just change the file path
FOR EACH file in FileList('Filepath\*.xlsx');
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
If Wildmatch(sheetName, 'Region*','Area*') Then
From $(file)(ooxml, embedded labels, table is [$(sheetName)]);
Drop table tables;
Hi Avinash can please let me know will there be any issue with the file format.
1. Present loading .xlsx file but throwing an error "field not found"
2. When running through QMC then "SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
this indicates a mismatch between 32 and 64 components:
][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Yes , that is the issue , since you have mentioned the field name it is excepting same field names in all the sheets that's why its give the problem
But the structure across all the sheets is one and the same.
Moreover some times getting _xlnm#_FilterDatabase issue as well.
Its duplicating sheet names by appending _xlnm#_FilterDatabase.
Using user DSN I am trying to load the excel data
When I am loading the data in server the above error was coming