Thanks for the input,

Still investigating all angles,

Might give up and create a BULK INSERT script instead, as that may just do what i want it too...

thanks again to all who...

I can foresee a few sleepless nights ahead then!

Many thanks for your suggestions on this,

If anyone reading this just happens to have a code example in their back pocket, it...

I like that idea a lot,

the files all contain header records, so could i not use aspects of the array to produce the column headers?

I think i will have some...

Sadly the "interesting" data is column 20 onwards.

I suppose what im looking for is something that will import a file that may contain 1-x columns and import them all as...