A Comparison of SAS versus Microsoft Excel and Access
There are a great variety of business situations where it is necessary to automatically export data from a large number of similar Microsoft Excel spreadsheets (perhaps reports, forms etc.) into a central database, without access to a SAS installation.
This paper will show how to use Microsoft Excel and Microsoft Access’s inbuilt VBA functionality to program this type of export.