Sql server provides different options for import and export data from sql server to another media like text file, excel or even in another database. One way of exporting data to excel or flat file is using  import export wizards  option of DTS (Data transformation Service). Same thing can be done using BULIK copy (bcp command) and ...