Please disregard this post. A solution was provided in the Access forum by 3
guys that absolutely ROCK!!!

"Sky Warren" wrote:

Hello,

Can someone write the steps neccessary to trim trailing space from records
in a worksheet. What I need to do is import an excel database into Access,
but the fields in the excel worksheet have trailing space at the end. Is
there a way to TRIM the worksheet of trailing space prior to importing it
into Access?