This information applies to Pinnacle Studio & Avid Studio which runs on iOS.
Yes, using the Apple iPad Camera Connection Kit. http://www.apple.com/
Transfer the media to your device, and it will be available for use in Avid Studio.
For more information on how to use the iPad Camera Connection Kit, please see this FAQ from Apple's website: http://support.apple.com/kb/HT4101