The #Attachment data type in Microsoft #Access tables is a useful and convenient way to store files together with associated records in your #MsAccess database.
In this video I show how you can extract all the files from any Attachment column in any table in your database back to a folder in the file system with VBA.
A sample file containing the procedures shown in this video can be downloaded here: codekabinett.com/download/Extr...
00:00 Intro
00:55 Scenarios when to extract files from an Attachment field
04:50 How Attachments work in tables and queries
11:15 How to Extract Attachments with VBA
23:03 How to Extract Attachments from linked SharePoint lists
----------------------------------------------------
I created a complete online course "Learning VBA Programming". A course for beginners and intermediates in VBA to learn from the ground up.
If you want to know more about the course: codekabinett.com/courses/inde...
Негізгі бет Ғылым және технология How to Extract Files from an Access Attachment with VBA
Пікірлер: 29