I am trying to move a database from MS Access to SQL Server 2014 and I am using SSMA for Access. A few of the tables have attachments (pdfs, jpgs, emails, etc.).
Is there anyway to do this from MS Access side or SQL Server side?
I downloaded all the files to my system and was thinking of matching the names with the files in the folder to upload them to the database through SQL, but then there are multiple files for one row in some instances, so basically I'm not sure how to go about it.