Yes. Install the codex that comes with the flip and you will have to use the option “open file” from the file menu. the flip doesn’t work like a normal minidv camcorder.
Check out this article at MacWorld, specifically scroll down to the “The software and alternatives” heading, to see how you would do it. While they are using the newest iMovie, it should work in ‘06.