BCP in and out commands

EXPORT TO DAT FILE

declare @sql varchar(8000)

select @sql = 'bcp database..tablename out c:\table.dat -T -c'

print @sql

exec master..xp_cmdshell @sql

IMPORT FROM DAT FILE

declare @sql varchar(8000)

select @sql = 'bcp database..tablename in c:\table.dat -T -c'

print @sql

exec master..xp_cmdshell @sql