Wednesday, December 17, 2008

BULK INSERT from a text (.csv) file - read only specific columns fields

BULK INSERT from a text (.csv) file - read only specific columns fields
This can be done using a format file with bcp. Here is the on line link to creating a format file for bcp.
http://msdn2.microsoft.com/en-us/library/ms191516.aspx

No comments: