Query to remove unwanted spaces before and after after conversion

[hunoob]

Hi Everyone! I have converted a txt file to access. The problem is that in some of the columns there are spaces in front of numbers or characters. Someone please could show me how to make a query which removes these unwanted spaces before or/and after. As I am very new to access please explain me detailed how/what should I do! Thank you very much in advance and have a nice weekend!

 

[ACMAIN_CHM]

for example, the tableA with column colC as below
colC
-------
aabcdf
vbd
v df

then you can use the TRIM() to remove the both prefix- and -suffix space.

update tableA set colC=trim(colC)

best regards
acmain