Connecting SAS to Access 2007 (.accdb)

This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post.

Here is a working example of how to connect SAS 9.1.3 SP4 to a Microsoft Office Access 2007 .accdb data source. First, let’s use a pass through query. The file is called c:\saves.accdb and contains a table called table1. proc sql; /* create an ODBC pass-through connection using the Microsoft Office Access 2007 .accdb driver […]

This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post.