I've got a brand new MacBook Pro running Snow Leopard and I'm wondering what cable I need to buy in order to import video from my Canon XL1 which has the older version of the firewire cable.

Same question. Who has the answer?

You can buy an adapter from the apple store.

Moshi 800 to 400 FireWire Adapter - Apple Store (U.S.)