BCP is a command line tool that allows you to obtain data quickly, whether that data is in or out of a database or tables. The script below uses an undocumented stored procedure to go through each table in the NorthWind database, BCP-ing the contents of each table out to a file (in the format tablename.txt) on the C drive. You can change the database name as appropriate.
sp_msForEachTable @Command1="master..xp_cmdshell 'BCP NorthWind.? out C:?.txt -SNorthwind -U sa -P -n' "