Access VBA Find and replace within a table and field

Hi

How do I do a find and replace within a table or a field
within that table.

eg replace "D" with "C" within tblTest
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rockiroadsConnect With a Mentor Commented:
All occurrences of the character?

e.g. run this query

update mytable
set myfield = replace(myfield,"D","C")


obviously do backups of your db/table before modifying data
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great thanks.

Yes all occurrences.

Thanks again for such a quick and concise answer

0
 
rockiroadsCommented:
no worries :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.