Sql 2000 format file

Hope this helps someone. Improve this answer. Randy J Randy J 1, 1 1 gold badge 8 8 silver badges 3 3 bronze badges. Thanks Randy J. Changed the accepted answer because this is a better solution. Unfortunately this didn't work for my unix file which is terminated with LF but the dynamic SQL solution did work! Thank you! I only wasted about 10 minutes screwing around with the rowterminator before I found this post. Could have been much worse Yes Randy that helps a lot!

Thank you so much I was going nuts. Thank you!! You just saved me two hours each month! Show 1 more comment. Thanks to all who have answered but I found my preferred solution. Will Rayer Will Rayer. It does, hence its ability to use bcp files to specify the input format. But you will have to have an extra step! Possibility 4 is farfetched. It happens in email, but that is another story. Philippe Payant Philippe Payant 6 6 bronze badges. BankZ BankZ 2, 1 1 gold badge 11 11 silver badges 8 8 bronze badges.

Yes, you would think it would work. And so did most of us. But it doesn't. The following is an example of the format file without the collation info.

The format option always requires the -f option, and to create an XML format file, you must also specify the -x option, such as:. To distinguish an XML format file, we recommend that you use. This section contains the following examples that show how to use bcp commands to create an XML format file:.

Adventure Works Cycles is a fictional manufacturing company used to demonstrate database concepts and scenarios. As created by bcp , a format file describes all the table columns in order. You can modify a format file to rearrange or omit table rows.

This lets you customize a format file to a data file whose fields do not map directly to the table columns. For more information, see the following topics:. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note The version of the bcp utility Bcp.

To use a bcp command to create a format file, specify the format argument and use nul instead of a data-file path. The format option also requires the -f option. In addition, for this example, the qualifier c is used to specify character data, t, is used to specify a comma as a field terminator , and T is used to specify a trusted connection using integrated security.

At a command prompt, enter the following command:. Otherwise you will likely receive the following error message:. The following command will use the bcp utility to create an xml format file, myFirstImport. The format option always requires the -f option, and to create an XML format file, you must also specify the -x option. Skip to main content.