Removing unwanted data when importing from CSV file

[mrkipling]

I have a script triggered by a timer, that imports csv files when they are uploaded to a file.
In one of the fields - "Car Description" each record has some unwanted characters at the beginning and the end. These unwanted characters are the same in each record.

Can i set anything in table design that will not allow these charactes to be imported, or will I need to remove these characters another way.

Thanks

Mark

 

[Pat Hartman]

You'll need to run an update query after the data is imported.