From Newsgroup: comp.databases.ms-access
I know that I am replying on old post, but this post helped me a lot to understand the case. After that I used third party application that helped me in migration. So, I am sharing official page link here, it can help users to reach right solution easily.
https://www.systoolsgroup.com/access/sql/
--- Synchronet 3.21b-Linux NewsLink 1.2