Date:         Tue, 21 Sep 2010 16:14:20 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Reading MS-Access ADP Files
Comments: To: Kristin Graves <gravesk@coned.com>
In-Reply-To:  <201009212041.o8LAnP0W012795@willow.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

I don't know much about ADPs, but Google seems to indicate that an ADP is
basically an access database without the database; ie, no actual data in it,
just the queries, forms, etc. , and it is intended to interface with a SQL
database via OLEDB.  If that's right then you probably should look at the
SQL database itself.

-Joe

On Tue, Sep 21, 2010 at 3:41 PM, Kristin Graves <gravesk@coned.com> wrote:

> 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
>