Tell me how i can Connect Server database using DSN or any other way..... ?

My Server in US so i want to connect this database using DSN.
My programme in Excel. and i want to connect from india.
Please tell me this possible ?.... By Mahesh