Heh... I've gotta agree with that part... we've gotten more done on cocktail napkins that we have at such seminars.

Beer... the greatest "networking" tool there is

Just don't forget the "-s" (column separator) flag... might want to set it to -s"" so there is no separator...

And, yes, you could use BCP for a fixed file format......

... or....

You could import whole lines into a very wide column and split them there using a split function...

... or ...

You could do the same but a bit different... import...

You bet, folks... thanks for the feedback.

Heh... no, Greg... not about good "lurkers" like you ... it's about some folks who will never "get it".

Thanks John and Rog... much appreciated!

You may be using the wrong layer to do database things in.  The type of activety that you've both described should probably be done in...

Because the "pipe" character is not one of those "special" characters... \t doesn't mean "use [t] as the delimiter", for example... it means "use a tab as the delimiter".  the [|]...

Ok... thanks!  I'll put my soapbox away

I'm pretty sure that OpenRowSet wants constants, not caclulations, as it's operands.  You'll probably need to shift the whole thing to dynamic SQL.

Guess we'll need to see the rest... no errors there except can't see where the starting and ending quotes are at the beginning and end of your snippet.

Thanks...

Lowell does do a great job, but lemme ask you Cees... have you calculated the header or are you going to manually change it in the code?

That IS a good article... thanks, Ken.

Heh... You beat me to it! 

And, if you can't afford that kind of schooling for the company, at least read about change management and change control.  Use Access or...

Ummm.... wouldn't a CHECKSUM or BINARY_CHECKSUM at the row level be a little easier?