Adding attachments to SQL table

Question

We are in the process of transitioning from an Access DB to SQL server tables due to size limitations and are having issues getting the "attachment" field type which contains several pdf attachments out of Access and into a varbinary(max) field in the SQL table.

Has anyone had any experience with this process either using Alteryx or other scripting tools.

Thanks,

Joe

Joe_McCoy · Answer

Gabriel, thanks for the reply. We were looking for a potential Alteryx solution and had already reviewed that site you linked. We have decided to go another route. Link below.

https://www.devhut.net/adding-attachments-to-an-access-database/

gabrielvilella · Answer

In order to insert a file within a field on SQL Server you need a blob field type. You might need to adjust your query, a quick Google showed me this: https://stackoverflow.com/questions/18411106/inserting-a-pdf-file-to-sql-table-using-sql