You need Quicktime for Sonar to load mp4 videos. Since it's only available in a 32 bit form, you need to run the Sonar 32 bit version, which will work even on the 64 bit versions of Windows.
Then when you go to import the video, under the "Files of type" dropdown list, choose "All Files (*.*)" and your mp4 video will be visible.