Choose "Import the Source Data Into a New Table in the Current Database" and select "OK." ... Select each table you want to copy from the SQL Server database to your Access database.

Processing is carried out by SQL Server on the database server, not in Access on the client side. As a result, you’ll see a reduction in network traffic (as opposed to a split MDB).