Overview of Importing and Exporting Data Import with BCP or SQL statements Bulk Overview Import and Export Bulk Data by Using the bcp Utility Import Bulk Data by Using BULK INSERT or OPENROWSET(BULK...) Prerequisites for Minimal Logging in Bulk Import Prepare to Bulk Import Data Prepare Data for Bulk Export or Import HumanResources.myTeam Sample Table Data Formats for Bulk Import or Bulk Export Use Native Format to Import or Export Data Use Character Format to Import or Export Data Use Unicode Native Format to Import or Export Data Use Unicode Character Format to Import or Export Data Import Native and Character Format Data from Earlier Versions of SQL Server Specify Data Formats for Compatibility when Using bcp Specify File Storage Type by Using bcp Specify Prefix Length in Data Files by Using bcp Specify Field Length by Using bcp Specify Field and Row Terminators Keep Nulls or Use Default Values During Bulk Import Keep Identity Values When Bulk Importing Data Bulk Import Large-Object Data by using the OPENROWSET Bulk Rowset Provider Format Files for Importing or Exporting Data Non-XML Format Files XML Format Files Create a Format File Use a Format File to Bulk Import Data Use a Format File to Skip a Table Column Use a Format File to Skip a Data Field Use a Format File to Map Table Columns to Data-File Fields Import Flat File with the Import Flat File Wizard Import and Export with the Import and Export Wizard Import from Excel Import JSON Documents Import and Export XML Documents Import and Export from Azure Blob Storage