If you have the LeapFrog Connect software that came with the Leap Pad 2, then transferring photos, artwork, and videos is easy. Accessing those photos on your local hard drive is just as easy, although not very intuitive.
When you plug the Leappad 2 into the USB port of your computer, the software should open and ask you if you want to upload new content. After you choose "yes" that content can be viewed in the Creative Gallery. On the top right corner of the creative gallery, you will see a link that says "Local Files." I am including a picture to make this easier to find. The link will direct you to the place on your hard drive where all the pictures, artwork, and videos from your LeapPad are stored. You can then move them to any folder or harddrive on your computer.
The folder on my computer can be found at C:\Users\Public\Public Documents\LeapFrog - your folder is probably in the same place.