I have tried to get data from Citadel 4.0 database to Excel.
It work fine with Query but I would like to use SQL.REQUEST function.
I have not succeeded yet. The function replies N/A, which indicates that there is something wrong with the connect string.
The connect string is "DSN=ODBC_DB_NAME" where ODBC_DB_NAME is the name of my ODBC database (Citadel 4.0 database) that I have declared from Control panel -> ODBC datasources.
It this fuction compatiple with Citadel 4.0(5.0)?
If so, how should I plase the connect string and other parameter in the function that it would work OK?