Find Replace in Imported Spreadsheet

[GavZ]

Hi,

I have a table which holds an imported spread sheet. how can i remove all of the spaces in all of the fields without doing the long winded ctrl + h.

Is there any VB that would do it that i can run at the same time as the import?

Thanks
Gav

 

[CBrighton]

The trim functions can remove trailing / leading whitespace, but if you want all of it gone you could try the replace function:

http://www.techonthenet.com/access/functions/string/replace.php

However I've never used it to purely remove data so I'm not sure if it will accept "" as the replacement.