Not sure what records you are looking at - is it the so-called "Canada, British Regimental Registers of Service, 1756-1900" on Ancestry?
I can see a Michl Stapleton there in the 27th Light Dragoons, born Burr circa 1778, attested 25 March 1796 (presumably for the 30th Dragoons with which former service is noted), invalided 24 November 1798.
These records are British regimental registers - note that there is not necessarily any connection with Canada.