saving data from Attachment field to local drive

[saleemsadique]

I have 10 thousand records in a table. each record has two attached files in single attachment field.
my requirement is to save all the attached files from all records to local drive in one go.
how can I perform this action in Access 2013 64 bit

[ssanfu]

I have never saved documents in the BE. But I Googled

saving data from Attachment field to local drive

and found this: http://www.access-programmers.co.uk/...d.php?t=228146

Maybe it will help. Be sure and read the whole thread......

[June7]

Hopefully this will help. https://www.accessforums.net/access/...eld-40827.html

The link in post 2 seems to have gone bad but download the example in post 5.

[ItsMe]

I believe that example will require an additional loop (code) to iterate the attachment field since the user stated there is more than one attachment in a given field.

[saleemsadique]

thanks ssanfu this resolved my issue

[saleemsadique]

Thanks ssanfu this resolved my issue

Thanks to all of you,
you guys are great