I have a Remote Desktop Session which allows me to run Excel 2010 and through the DATA Options in Excel, select a connection to an SQL Server Database.

The connection allows me to select ANY or ALL Tables in the database and Export them to Excel - I have all permissions while in RDP to do this

The problem is that I can only export the data to Excel, which means that if I want the data from a few tables I am basically manually driving the export, which can be very lengthy

Can anyone suggest another way to get to the data (other than Excel) so that I am not manually doing the operation step by step every time.

Ideally I set up a connection without going through RDP and write some code to achieve the extraction automatically

Many Thanks