Select each table you want to copy from the SQL Server database to your Access database. Choose "OK" to start the import and then "Close" when the import is complete.

Linking Vs. Importing Files in Access. Microsoft introduced its Access database product about 20 years ago, and it remains popular due to its ability to link and import data from a variety of sources.

In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly without first explicitly connecting to a DBMS (see CONNECT Statement). If you omit the CONNECT statement, an implicit ...