dbForge Data Pump for SQL Server is an SSMS add-in for populating SQL databases with external source data and migrating data between systems. This tool supports import and export from 10+ most widely used data formats (including TXT, SQL, HTML, MS Excel, XML, RTF, PDF, DBF, JSON, ODBC, and CSV) and includes a number of advanced options and templates for recurring scenarios.
Getting started with data export
Getting started with data import
Transferring data to other servers through ODBC drivers
Loading data from other servers through ODBC drivers
Using the command line for data export