Multiple search and replace

[mbvis]

Hello,

I have a database with 17,000 records. I want to know if it is possible to make a batch file where I can find and replace a lot of things at ones. For example:

Search Arens replace in A.
Search Kampen replace in K.
Search Ellis replace in E.

Is there a SQL statement or module?

Thanks a lot,

 

[PWise]

Arens, Kampen, Ellis

Are these field names or table names or dhe data in fields?

 

[JoeAtWork]

For each replacement you need an SQL update something like:

UPDATE TheTable SET TheField = 'A' WHERE TheField='Arens'

If your list of replacements is in a consistent electronic format (Excel sheet, CSV file, etc.) then you could write code to loop through the list, building and running each SQL Update one at a time.


Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[mbvis]

Thanks for your replay. I have all the replacements in an electronic format. But how must i write the code? Is this in VBA as a module in Access?