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?

Take a look he

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


In article ,
"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?

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?

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/...b0bcc0a46fa831

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

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