[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

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
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
rockiroadsCommented:
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now