Hi Marcus, Thanx, but I have 5 files (with 3 different Headers in Column 2, and all 5 have different headers in the subsequent columns) so I would be more efficient to use embedded labels and have 3 load scripts rather than have 5 load scripts without embedded labels.
I suspect what I want to do is not possible, but I wondered if perhaps it could be done by maybe creating an empty table then loading data in to it.
I wouldn't say that is impossible but definitely not useful - different is different and every difference needed to be handled with some condition (perhaps in loops with variables and/or the rename-statement). But in your case with only a few tables/fields it would be faster and better to keep the script simple.
Cheers Marcus - I was hoping because the files were so similar that there'd be an easy / graceful work-around. At present I can just do it with 3 load scripts but I've no idea if in the future there'll be more similar files to process that will require more scripts.