Exporting from Access

[jayhart@verizon.net]

When I export a table from Access into a tab-delimited text format,
there are unwanted spaces after my data. How do I fix this? Does it
have something to do with my field sizes?
See below for an example, how do I eliminate the space after
"Aaron "?

"Aaron " "E
" "Sher "

[KC-Mass]

Re: Exporting from Access

I would suspect that the strings actually in the fields are padded with
spaces.

To check test the length of the data not the field. something like
intDataSize = Len(FirstName)
and then
intDataSize2 = Len(Trim((First Name))

If they are not the same as each other and the len is longer than the count
of
visible characters, they are padded.

You can remove that with an update query where fieldName is updated to
Trim(fieldName)

Regards

Kevin


<jayhart@verizo n.netwrote in message
news:411ce80b-2af3-4980-85ab-5aa343bf206c@j2 2g2000hsf.googl egroups.com...

When I export a table from Access into a tab-delimited text format,
there are unwanted spaces after my data. How do I fix this? Does it
have something to do with my field sizes?
See below for an example, how do I eliminate the space after
"Aaron "?
>
"Aaron " "E
" "Sher "