Date:         Tue, 21 Sep 2010 16:41:53 -0400
Reply-To:     Kristin Graves <gravesk@CONED.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kristin Graves <gravesk@CONED.COM>
Subject:      Reading MS-Access ADP Files

Hello -

I am trying to read a MS-Access ADP file.  I have SAS Access to PC File
Formats, but do not have SAS Access to ODBC.  I am using SAS 9.1 but do
have another machine with a more recent version.


This is the code that I used:
%let insmart=Z:\Smart Meter Portal\smart meter.adp;
libname insmart access "&insmart";


And here is the error message:
119  * LIBREF FOR INPUT DEVICE-CHANNEL FILE;
120  libname insmart access "&insmart";
ERROR: Connect: Unrecognized database format 'Z:\Smart Meter Portal\smart
meter.adp'.
ERROR: Error in the LIBNAME statement.


Do I just need to modify my libname statement somehow?  Or is SAS not able
to read adp files?

thanks for your help,
Kristin Graves