If the video files you want to use are on a DVD, then you may have some problems. If the video was written as a movie (DVD Player opens when you insert the disc into the Mac) then you won't be able to just copy it off. If the video was burned as a regular .mov file or something else, you should be able to either drag it off of the disc to the desktop or import it all into iMovie.
If you are using MiniDV tapes with this Sony camcorder, iMovie should allow you to import directly from the camera, provided you have a FireWire port and cable. I have done this many times before, and like many programs and cameras, the only drawback is it imports in real time, so you'll have to wait/watch the clips as they are copied. If you're not using MiniDV tapes, have some other kind of camcorder, let us know. And what happened to the original video (before you put it on the DVD)? If that's gone, there may be some more issues. Provide us with more information, such as the type of Sony camera you have, what type of Mac you are using, what OS is on the Mac, and the version of iMovie. To find out about the Mac, click the Apple at the top-left of the screen. Select "About This Mac" to find the CPU type and OS version. For iMovie, click "iMovie" at the top of the screen as well, and click on "About iMovie". Software version should be listed. It helps to know this because iMovie is different from its predecessor, iMovie HD. Another way to differentiate between iMovie versions is the dock icon. Is it a blue icon or a yellow star? Let us know how you get on.
-BMF
My daughter recorded something on iMovie, but she wanted to import some video she took from our camcorder. She put the video on a DVD but she can't seem to drag the video onto her existing iMovie.
I called Apple's support service and they suggested I try loading the video directly from the camcorder but they couldn't help me with that as it's not an Apple product (the camcorder is a: Sony) They suggested to put the camcorder on some type of mode that the computer could recognize????
The other suggestion they made was to get a third party application that can "rip" the images from the DVD so it can be imported into iMovie. Again, they couldn't help me because it's not their product.
I'm not very really familiar with any of these things so I was hoping someone would be willing to help me figure it.
Any assistance or guidance would be greatly appreciated.
Thank you,
Pinky

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic