Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Find and Replace between Access and Text File

Author  Topic 

smith7255
Starting Member

5 Posts

Posted - 2007-05-16 : 14:05:22
I was wondering if it is possible to have a table with two columns in it, let's call them OldValue and NewValue, find the OldValue in a text file and replace it with the NewValue. Any information on this would be helpful. If it can't be done in Access, are there any other suggestions. I use access a lot, but I don't really script.

smith7255
Starting Member

5 Posts

Posted - 2007-05-22 : 16:08:16
I know how to use DAO.Recordset but I am not clear on how to use anything else. I generally do the same things over again so I just copy my script. I don't know how to open an external document in a case like this and search it. Any suggestions at all?
Go to Top of Page
   

- Advertisement -