How can i remove " " form the MS Access table ?

  • Thread starter Arun Kumar Leninsankar
  • Start date
A

Arun Kumar Leninsankar

when i import data to access table from excel. tables are filled with " ".
how can i remove this " " from my table. this is not aleading or trailing
space.It is just a space instead of null.
 
D

Douglas J. Steele

<picky>
If it's just a space, then it's both a leading and a trailing space.
</picky>

If it truly is a space, the Trim function should work on it. If it doesn't,
then my suspicion is it's not actually a space but some unprintable
character and you'll need to use the Asc function to find out what.
 
Top