I don't think there is any way to speed up this process in Access. The process is inserting a single row at a time - and that insert operation is sent across the network to SQL Server.
If the data is in Access - it might be better/easier to export the data to a file and use BCP to load the data to SQL Server. Or - setup a linked server in SQL Server to the Access database and pull the data from Access.