Data Transfer From Microsoft Access to SAS Made Easy

Overview

To transfer data from Microsoft Access database to SAS has never been easy. Unlike Oracle database, neither SAS PROC SQL pass-through facility nor SAS/ACCESS can directly view or retrieve data from Access database tables. Users have to undergo a very complicated process in order to import data from Access without the help of additional software. This paper proposes an easy way to extract data from Access without any other additional cost. It is quick and automatic.