Question: how to export the table data from sql server?
Answer: SQL Server import and export wizard To begin, open the Import and export wizard, right-click a database and select the Tasks sub-menu -> Export data command: Connect to a source database via the Choose a data source step. Connect to a destination SQL Server database in the Choose a destination step.