Forum Discussion

EMR88's avatar
EMR88
Copper Contributor
Sep 19, 2021

Migrating to SQL from Access

I am about to hit the Access 2Gb database file size limit.  I would like to migrate my Access db to SQL Server using the SQL Server Migration Assistant for Access.  However, the documentation has the filing caveat:

  • Remove the Attachment column    SSMA doesn't migrate tables that contain the Attachment column.

https://support.microsoft.com/en-us/office/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979

 

This Access db has hundreds of file attachments.  How can I migrate the Access db to SQL?  Thank you.

No RepliesBe the first to reply