Thanks all

Looks like if i redo it with bcp i can get what i need

Will probably take a bit of time to get it to do what i want and...

Thanks

I had a feeling that might be the case

Does bcp support separators of more than 1 character?

Thanks for taking a look at it John Mitchell-245523

Managed to get it to work just now

Turned out to be very simple - i had just missed off the select line...

Thanks

I'm using the default microsoft sql server driver as in this one (not my screenshot but easier to find one in google images than upload one):

Used most of the default...

Thanks for that and apologies for the delay in replying

I will give those tips a try and look like what I was after

Partitioning is probably something we will look at...