There are 2 viable methods
1. BCP , if ur file is at different server and u can access this file on ur ur server then u can use UNC naming convention to access this file and dump data into Database.
2. DTS or SSIS , Just dig in for with appropriate option .