Thanks all. Changing the 4 backup N sorted it.

The reason I rewrote was due to getting syntax so I tried to resolve before asking.

I didn't post the original table...

I have managed to solve the syntax error, by doing:

and i do...

This is the code which i am using, but i am getting incorrect syntax near 4 which is on the cross join line...

INSERT INTO mytable

...

Thanks for your replies. I think I have sorted it. I am now exporting from the source in a flat file. I am then using the import...