Extra Character

[TeeSee]

Trying to import a file sent from a customer, however there is blank
after each item code in a specific field which needs to match up with
same field in a separate table. How best (efficiently) to strip that
blank away??

Thanks

 

[Ken Snell \(MVP\)]

You can run an update query on the table after importing the data and strip
off the trailing blank space:

UPDATE TableName
SET FieldName = Trim(FieldName);