How to select a database in SSMS

Selecting the required database is as easy as it gets. Find and right-click the database in the SSMS Object Explorer to invoke the shortcut menu. Point to Data Pump and click Import Data to proceed.

Selecting Data Pump from the shortcut menu

Your further actions depend on the required format:

  • Import data from a text file
  • Import data from XLS
  • Import data from XLSX
  • Import data from Microsoft Access
  • Import data from XML
  • Import data from JSON
  • Import data from CSV
  • Import data from ODBC
  • Import data from DBF
  • Import data from Google Sheets
  • Save and use data import templates for recurring scenarios