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

[#1]

Hi,

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

[Anonymous]

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

[#3]

done. Thanks.