Trimming data and updating table info 1

[balllian]

I have the following data which populates certain fields within my database.

this appears as follows.'%20GBWTB0052E'

i need the data to appear as 'GBWTB0052E'

what is the best way to change what records appear with %20 to be chnaged so that they then appear within the database in the correct format.

Im currently using the find and replace function which is very labour intensive and wish to find an automated way of changing these records.

Thanks in advance

 

[balllian]

are u transfering data from one table to another or importing a text file into an access table?

 

[olivier1978]

I am transfering data from one table to another.

 

[balllian]

why dont use the append query to add additional information from one table to another.

 

[PHV]

olivier1978, the JetSQL way to achieve your issue:
UPDATE destTable INNER JOIN srcTable
ON destTable.SomeField = srcTable.JoinedField
SET destTable.newField = srcTable.SourceField;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886