Importing and Exporting Bulk Data
Microsoft SQL Server allows you to import and export data in bulk (bulk data) between a SQL Server table and a data file. This is essential to efficient transfer data between SQL Server and heterogeneous data sources. Bulk exporting refers to copying data from a SQL Server table to a data file. Bulk importing refers to loading data from a data file into a SQL Server table. For example, you can export data from a Microsoft Excel application to a data file and then bulk import that data into a SQL Server table.