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