How to use TRIM function

[Guest]

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?

 

[JE McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[Guest]

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

 

[David McRitchie]

Hi Sky,

FWIW the access solution in an Access newsgroup group was
sorry for the beta.google format -- I hope this is short-lived on
Google's part.
http://groups-beta.google.com/group...ss.reports/browse_frm/thread/00b0bcc0a46fa831

I usually go with trying to fix data at the source (GIGO, garbage in garbage out)
if I have control of both.