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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking changes to a form 3
Tracking changes to a form's fields---still searching for an answe 6
Find and replace values from a table 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
trying to track deletions in a text box 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Recurring import of linked text file data 10
Best way to import text file into existing table on a daily basis 15

Top