How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?
April 17, 2004 6:49 PM Subscribe
Say I have a database
there is a table called
In this table is a field named
. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
posted by Grod to computers & internet (14 answers total)
Why are all the google ads about social security? Shouldn't they be about database programming?