Hi johnr,

The sample you posted appears to have row delimiters in it. If there are no row delimiters at all, and the file looks like this:

TEST1ABCTEST2DEFTEST3 TEST4GHI

Then you'll probably have some problems. If the file looks like this:

TEST1ABC

TEST2DEF

TEST3

TEST4GHI

And there actually are row delimiters, then the BCP format file trick should work. What you seem to be indicating though, is that you want to essentially rotate the columns and rows. I believe there's an SSIS transformation to do something similar, although if not you can bulk load into a temp table and perform a few INSERT...SELECT FROM... statements to move the data from the temp table into your permanent table pretty easily.