I have a company spreadsheet as well as seperate ID photos that I would like to import into a basic dB I have setup.
The spreadsheet basically has the following information:
Last Name, First Name, Employee Number, and Employment Status.
There are ID photos which have filenames corresponding to their Employee Number. So for Example my entry would be:
O'Brien, Andy, 2839, Current
There's a file called 2839.JPG which is my ID photo. Is there anyway to quickly copy the ID photo into the record with the corresponding employee number, and if so how?
Any help appreciated.
Andy
