That is the issue with ADO with Excel.
Whatever length you specify while creating the table, that is ignored.
ADO RecordSet field object always shows oField:DefinedSize as 255.
However, the footer shows a fractional number - 9999.0
:aCols[1]:FooterType:=AGGR_SUM
:aCols[1]:FooterPicture:="9999"