[snerbles]

If the MS Access application is backed by an actual MS SQL server, maybe. But if (and in my experience this is more likely) it uses MS Access itself with MDB files (Microsoft's Jet database engine - imagine SQLite but inferior in every conceivable way), you're probably better off writing a tool in .NET or similar to migrate the data.

In a past job supporting an industrial controls firm, I wrote an interactive merge tool for AutoCAD Electrical parts catalog files (hideous little MDBs behind the scenes)...it was an unholy clusterfuck of C#, Lucene, NodeJS, and a smidgen of VueJS on the frontend. Not my proudest work, but it sure beat the usual tasks involving VBA in FactoryTalk.