H
H. Zhu
There are many Microsoft Excel ODBC Query files. I am attaching one as an
sample. They could be edited with Microsoft Query or with Notepad. What the
files contain is SQL code; each file has only a few lines.
My task is to open each files, change one word, then close it. Specifically,
I need to replace the string "Database 2003.mdb" with "Database 2004.mdb".
My challenge is that there are several hundreds of them, which not only make
my task tedious but also make it impossible to avoid error.
Is there a quick way to do it?
Thanks in advance
Hong
sample. They could be edited with Microsoft Query or with Notepad. What the
files contain is SQL code; each file has only a few lines.
My task is to open each files, change one word, then close it. Specifically,
I need to replace the string "Database 2003.mdb" with "Database 2004.mdb".
My challenge is that there are several hundreds of them, which not only make
my task tedious but also make it impossible to avoid error.
Is there a quick way to do it?
Thanks in advance
Hong