BenWard (12/29/2014)
Ah yes I did mean columns.silly mistake there!
In that case, BCP will still work. You need to list the columns in your format file and give them the column position of "0", empty delimiters, and an input length of "0".
The other thing you might try is to BCP into a view that refers to the table. Of course, the view can be setup to have the columns in the same order as the file and you only need to list the columns that will be in a file. This won't, of course, work if you need to skip any columns that are in the file itself.
--Jeff Moden
Change is inevitable... Change for the better is not.