Quick Export/Import Table Data

NOTE: Type commands below under Command Prompt

Export:

bcp db_name.dbo.table_name out "c:\data\table_name.txt" -c -T

Import:

bcp db_name.dbo.table_name in "c:\data\table_name.txt" -c -T