How to check if connected to ODBC? Then proceed ex... - Qlik Community

Report Inappropriate Content · ‎2012-10-16

Hi,

How to do that? If not connected to odbc then read excel files.

Anonymous · ‎2012-10-16

You could use Set Errormode = 0; and then if the connection string fails you can instead load excel files using this after your connection string:

if ScriptError>0 then

LOAD EXCEL FILES LOGIC

end if

Report Inappropriate Content · ‎2012-10-16

done. Thanks.

How to check if connected to ODBC? Then proceed excel file.