Taking a backup of a single table in the SQL Server
Right click the database; Tasks, Generate Scripts &amp; enable Script Data from the options. Select the table and Finish.

This will generate a CREATE TABLE followed by INSERTs for the data.