I've got a directory say \\zurich\images which contains 500 or so images
I've also got an Access 97 Database which has a table containing all the image filenames and another column giving a year.
what i'd like is to loop through that table and say for example the first filename is image1 and the year is 1914 check if the directory \\zurich\images\1914 exists - if it doesn't create the directory and copy the file from \\zurich\images into that new directory OR if the directory does exist then simply copy the file across
any code would be greatly appreciated
thanks
sam
I've also got an Access 97 Database which has a table containing all the image filenames and another column giving a year.
what i'd like is to loop through that table and say for example the first filename is image1 and the year is 1914 check if the directory \\zurich\images\1914 exists - if it doesn't create the directory and copy the file from \\zurich\images into that new directory OR if the directory does exist then simply copy the file across
any code would be greatly appreciated
thanks
sam