Removal of Blank Spaces on an Import

[Guest]

There is one type of import I do from a source, and when I bring the
information in, the entire area after the "words" is all blank spaces, but
are being counted as spaces in Access. I have to go through each and every
field in each and every row, and manually delete the extra blank spaces
before I can append to my main table.
For example

Field 1
Joe________ (The line represents the blank spaces) I have to click in the
field after "Joe" and hit the backspace so the blank spaces disappear. My
question is, Is there a query or something to help eliminate the blank spaces
all at one time instead of me having to do it field by field and record by
record.

Thanks for any help anyone can give!

Tara

 

[Guest]

I have not found Access to retain trailing blank spaces but you could use an
append query that trims them.

Trim([YourImportField1]) Trim([YourImportField2]) etc.

 

[Guest]

Thank you, I tried it and it worked!!!! This will definatley save me tonz of
time!

I have not found Access to retain trailing blank spaces but you could use an
append query that trims them.

Trim([YourImportField1]) Trim([YourImportField2]) etc.

There is one type of import I do from a source, and when I bring the
information in, the entire area after the "words" is all blank spaces, but
are being counted as spaces in Access. I have to go through each and every
field in each and every row, and manually delete the extra blank spaces
before I can append to my main table.
For example

Field 1
Joe________ (The line represents the blank spaces) I have to click in the
field after "Joe" and hit the backspace so the blank spaces disappear. My
question is, Is there a query or something to help eliminate the blank spaces
all at one time instead of me having to do it field by field and record by
record.

Thanks for any help anyone can give!

Tara