Transform data to a new structure
You could look at using SSIS (part of SQL Server) which is a comprehensive set of tools for doing ETL.
The current tool of choice is SQL Server Migration Assistant (for the appropriate source database, i.e., comes in Access, Oracle, etc. flavors). But it replicates your Access database structure from scratch, rather than importing the data into your pre-built database.