Use the following steps to export all the data from the table to an insertable SQL format:
Step 1: Right-click on database
Step 2: Point to tasks.
Step 3: Select the generate scripts
Step 4: Click on next >> Choose tables >> Click next >> Click advanced
Step 5: Now, scroll to data to script - i.e. called types of data to script in SMSS 2014.
Step 6: Select the data only. Click on 'Ok' to close the advanced script options window
Step 7: Click on next and generate your own script.