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
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.
On Tue, Sep 21, 2010 at 3:41 PM, Kristin Graves <email@example.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
> 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