I have written a lot of code around a filed name. I realised after some testing that the data needs slight modification before it can be used.<br><br>HOW can I change a field name in VBA?<br><br>I could change the import spec and then rewrite a couple of queried but I would prefer to use VBA to change the name of column.<br><br>Cheers,<br>Davo