I am unable to get Connect to use a DBF inside a zip archive.
This fails with "#1105 - Cannot get columns from R_ACTE" :
CREATE TABLE R_ACTE engine=CONNECT table_type=DBF CHARSET=cp850 file_name="/tmp/CCAMArchiveLatest/CCAM_DBF.zip" zipped=1 option_list="Accept=1,Entry=R_ACTE.dbf";
As a workaround, unziping the archive in the same location and this would go thru :
CREATE TABLE R_ACTE engine=CONNECT table_type=DBF CHARSET=cp850 file_name="/tmp/CCAMArchiveLatest/R_ACTE.dbf" option_list="Accept=1";
The same issue happens for any DBF file from the same source. Those files are valid as per any other tools I've used to access them.
FYI, option Accept=1 is required to workaround another issue on using this kind of DBF.