How to export SQL Server data to multiple formats

You can easily export data from one or several tables in SQL Server databases using dbForge Data Pump. This topic will guide you through the following tasks:

  • Select the required database in SSMS
  • Export data to HTML
  • Export data to plain text
  • Export data to XLS
  • Export data to XLSX
  • Export data to Microsoft Access
  • Export data to RTF
  • Export data to PDF
  • Export data to JSON
  • Export data to XML
  • Export data to CSV
  • Export data to ODBC
  • Export data to DBF
  • Export data to SQL
  • Export data to Google Sheets
  • Save and use data export templates for recurring scenarios