Format Files for Importing or Exporting Data

A file that is used to store format information for each field in a data file relative to a specific table is called a format file. A format file provides all the format information that is required to bulk export or bulk import data. A format file provides a flexible system for writing data files that requires little or no editing to comply with other data formats or to read data files from other software.

The topics in this section describe the different types of format files that SQL Server 2005 supports, the structure and syntax of these files, and how to use them for bulk-import operations.

In This Section