Thanks for the reply.
I have found the problem. I was using a vehicle registration number as the ID column so in essence the ID was always the same for each row of data. I have used a unique ID now and it works!
Thanks also for the tip regarding Geomakepoint that will save me some time/hassle