Where are the blank characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using access 2002. I use transferspreadsheet command to transfer access
table to excel sheet. In the access table some fields contain one or more
blank characters. When the table is exported as excel, I notice that all the
blanks are gone! It seems that no matter how many blank characters I entry in
the access table, they are all gone when transfered to excel, but I want to
keep those blank characters. I have another 3rd party application that need
to read the excel file with blank characters.

Any body can help?
Thanks!
 
Blanks where?

If within strings, I would expect them to stay there.

If at the end of a string, I don't believe you've actually got them in
Access, as Access performs a RTrim before storing values.
 
Back
Top