Question: how to export and import table data in sql server 2014?
Answer: Open SQL Server 2014 Management Studio.
Connect to the database engine server.
Click on Databases and expand it.
Right click on the database that has to be exported and click on Tasks option from the drop-down menu.
From the menu, select the Export Data option.