I used the code on page 411 ( very slightly modified ), and managed to load a file to an attachment field. I think the problem is around the line(s) after 'Pass "" to match all files - which is exactly what I want to do i.e E:\FolderName\*.* for example. I get ( even after deleting attachment field and recreating it ) in destination table, a duplication error. Any thoughts ? Thanks.
Should the file name automatically change in the inner loop i.e
Do While Len(strFile) > 0