No, the kit is one-way, from the card or camera to the iPad, but you can copy photos off just by the USB cable that you use to charge/sync the iPad.
To copy photos to your computer that were taken with the iPad, copied to it via the camera connection kit, or saved from emails/websites then see this page - on a PC you can use the windows camera wizard, on a Mac you can use iPhoto, Aperture or Image Capture.
To copy photos that were originally synced from a computer you will need a third-party app such as Simple Transfer which can copy them off via your wifi network. But as photos are 'optimised' when they are synced to the iPad, any that you then copy back to a computer may not be exactly the same as they originally were on your computer.
The camera connection kit can only be used to import photo/video files from a camera, SD card or USB flash drive. You can't import other types of files. You can't export any type of files using the camera connection kit.
How to Transfer Photos from an iPad to a Computer
Importing Personal Photos and videos from your iOS device to your computer.