Adding attachments to SQL table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/
