Automatically adding file locations (pictures) to an Access database via PowerShell or Python -
i have microsoft access database, , pictures have file names matching entries in database (though part of file name irrelevant). need read file names , insert links them database attached correct entries. i've been playing around powershell , python while, have little experience access , can't find lot of documentation on subject. questions are: am better off using powershell, python, or else project? happen have experience 2 languages they're preferred jumping off point. i imagine take amount of work , don't mind getting hands dirty/doing lot of research, after looking around can't seem find place started. there specific commands, documentation, functions, etc. give me jumpstart on project? thanks! edit: @ako bringing point , concerned about. putting photos in db bad idea, i'd instead host them elsewhere automatically have links files generated in db based on file names , matching db entries.