Download table data from other Server

I just wanted to know is there any way by which we can dowload the data from some tables from Production Server while running the custom program in Development Server.

The user does not want to move the program to Production. Is there any way by which we can achive this.