I have data in Excel that is in 2 columns as below

Coloum 1 Coloum2
000199 CAON00000013
000200 CAON00000011


I wanted to create my SQL script from these columns as below

Update apdoc set user1 = 'Coloum2 value' where refnbr = 'Colum1 value'

As I have thousands of lines I have tried concatenate etc but it does not
come out ok as the ' don't come out ok and then leading 000 disappear in the
concatenate.

I would really appreciate some help on this.

Thanks

Sam