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
| Topic | Description |
|---|---|
Introduces the types of format files, describes the advantages of XML format files, and describes when a format file is required. |
|
Contains descriptions of non-XML format files, the original form of format file in Microsoft SQL Server. |
|
Contains descriptions of the syntax of XML format files and provides examples of XML format files. |
|
Contains instructions about how to use format files for typical bulk-import operations. |
See Also
Concepts
Data Formats for Importing or Exporting Data