I have a MS Access database that has one table that has an attachment field. The database has been in use for some time so there are several records in the table that have an attachment.
The issue now is we want to migrate the tables in the database to SQL. But SQL databases don't accommodate an attachment field. Is there a way to migrate to SQL without losing the attachment data somehow? I guess I'm hoping someone has run into this before and has a magic solution.