Bulk upload of attachments to table field

[Sanar1234]

I have linked a sharepoint list to ms access. It has 3 columns. One is Id , the other“employee name” and the third one “attachment field” . The table contains 500 records. Each field should be updated with a pdf attachment. At present i am manually attaching to each field. Is there a way to write a code to automate this process. All the pdf files saved on a drive, the name of pdf files saved with the “ID”. The vba should search the id name from the column “id”and search in the drive for the file and attach it to the attachment column

[ranman256]

you should keep the pdf files on the server and not in the db.
DO keep the path of the pdf file on the record.
Storing the pdf as attachment does dbl-duty and just fills up the database when you already are linked to the file itself.

[Sanar1234]

Thanks. But since i linked a sharepoint list with access. Whatever pdf i attach to the db access. It would be saved on the sharepoint file directory. I really need a code to attach pdfs to the database. Because then my business purpose will be solved. Kindly help me

[Welshgasman]

Look at using the dir() function to process the folder where the files are located.