Can I use apps other than Photos with Apple’s SD-card reader?
Apple's camera-connection hardware only interfaces with the Photos app, unfortunately. However, you should be able to transfer the photos from the photos app to Dropbox or a similar app after the import using the "send to" feature (I know it works with OneDrive and Google Drive).