Calibre can see the SD card and the internal memory of your ereader
Donwload the book imported in Calibre and from there upload it to the ereader
I keep my ereader in front of my main monitor so I can see both. The monitor has an USB port that I use to connect the ereader.
There is no way to automatically open that (have it to pop up on the screen)