jesusoneez
IT Dogsbody
- Local time
- Today, 07:14
- Joined
- Jan 22, 2001
- Messages
- 109
I'm not sure this is the right place nor am I sure Access is the right application but here goes.
I have around 1000 photos of students, and they are named (for example);
05162xxxxx.jpg
Where "xxxxx" is a random number. The filenames are in an Excel file, along with the student's name, student code and various other information...this can easily be imported into Access.
I need to rename each file as follows;
00xxxx.jpg
Where "xxxx" is the student code.
This is the only way our school management software will link to a students photo when viewing their records.
So, basically, I need Access to look at each filename in turn, compare it to the imported data, find the associated student code, and rename the file to that student code.
Is this possible?
I have around 1000 photos of students, and they are named (for example);
05162xxxxx.jpg
Where "xxxxx" is a random number. The filenames are in an Excel file, along with the student's name, student code and various other information...this can easily be imported into Access.
I need to rename each file as follows;
00xxxx.jpg
Where "xxxx" is the student code.
This is the only way our school management software will link to a students photo when viewing their records.
So, basically, I need Access to look at each filename in turn, compare it to the imported data, find the associated student code, and rename the file to that student code.
Is this possible?