Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Text File Properties

SQL Server 2000

Use this dialog box to set the data format of the source or destination text file. There are two data formats from which to choose: delimited and fixed field.



Specify that the source or destination text file uses delimiter characters to indicate columns.

Fixed field

Specify that the data in the source or destination text file is aligned into equal width columns.

Skip rows

Specify the number of rows you want skipped in a text file. This option only applies when the text file is used for source data.

First row has column names

Indicate that the first row in the specified file consists of column names.

File type

Specify whether the data file is ANSI (default), Unicode, or OEM.

Row delimiter

Specify whether the character that delimits rows in the data file is carriage return/line feed {CR}{LF} (default), carriage return {CR}, or line feed {LF}. You can also type another character.

Text qualifier

Specify whether quotation marks are to be used to qualify text in the data file.

© 2015 Microsoft