eliminating spaces in a field

[Schwoerer]

Hello,

I am having a problem importing a csv file into Access. In one of the fields, a few hundred lines have 3 blank spaces before the data. This, of course causes problems with maipulating the data in this field. Is there a way to shift everything to the left as you are able to do in Excel?

 

[Norie]

Well as in Excel you have the Trim function.

You could use this with an update query to remove the unwanted spaces from the field.

The SQL would look something like this:

UPDATE Table1 SET Table1.FieldA = Trim([FieldA]);

Where FieldA is the problem field.