How to Store Files in Microsoft Access

Want to load your Word, Excel, Text, Picture or other files into a field in Access? In this episode we're exploring how to load files into attachment fields in Microsoft Access. Sometimes it is handy to be able to store different kinds of files in your Access database so that you can instantly retrieve them for display or other uses. Most developers know that the best way to store a lot of files is to store a file's storage location in a text field (small amount of data) vs. storing the actual files (more data), but in some cases it is actually much better to store files in records in your database. Every use case is different, and today's episode handles the latter strategy. Today, I'm showing how to automate the storage of files in your database via the LoadFromFile method in VBA. Let's go!

#msaccess #vba

Видео How to Store Files in Microsoft Access канала Sean MacKenzie Data Engineering