Removal of Blank Spaces on an Import

K

ktfrubel

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
 
K

KARL DEWEY

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.
 
K

ktfrubel

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

KARL DEWEY said:
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.

ktfrubel said:
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
Click to expand...
Click to expand...
 
Top