Migrating to SQL from Access

Copper Contributor

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-4f...

 

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

0 Replies