After Effects does support AVI files. Maybe your PC is missing some codec or something like that.
If you have Adobe Premiere, open your files there and render a new AVI file using Microsoft DV Coded (or any other standard Coded…), if it’s possible for you, you’ll not have any kind of problem opening these new files into After Effects.
I hope it helps.