find and replace data in a text file using VBA from Access

  • Thread starter Thread starter smith7255
  • Start date Start date
S

smith7255

I am struggling with VBA. I don't use it. I have an access database
that has a table called Core that only contains two fields called
OldValue and NewValue. This table is udated daily and the number of
records vary. I have a text file C:\Core.txt and I would like to
search this text file for the data in Core's OldValue and replace that
it in the text file with Core's NewValue. Is this possible? Any
suggestions?
 
Back
Top