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.

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.

SAS/ACCESS software provides an interface between the SAS System and relational database management systems (DBMSs). In Version 6, the SAS/ACCESS interface consisted of one or more of the following: ...