Thanks, that's really helpful. I'm giving it a go today.

I've been trying to use BULK INSERT but I'm getting this error (which I'm in the process of trying to solve)

Cannot bulk load because the file "C:\users\xxx" could not be...

Is there any way of adapting this so that the query took for example the 5th value after a certain value came up in a delimited string? With the certain...