Date: Tue, 27 Feb 2001 05:07:12 -0500
Reply-To: Michael Davis <sas-l@BASSETTCONSULTING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Michael Davis <sas-l@BASSETTCONSULTING.COM>
Subject: Re: Access files and Drivers
Content-Type: text/plain; charset="us-ascii"; format=flowed
Hello Jacque and other friends,
You need a SAS ODBC driver to read ODBC data into SAS. I believe that you
have two choices: SAS/ACCESS Interface to ODBC or the Universal ODBC
driver. There are also third-party utilities that provide this
functionality that have been previously mentioned on this list. Good luck.
- Michael "Mad Doggy" Davis
At 04:46 PM 2/26/01 -0500, Jacques Thibault <jacques_t@HOTMAIL.COM> wrote:
>I'm trying to read an Microsoft Access db from SAS V8e, and I defined my
>connectivity in Control Panel --> Data Sources (ODBC), but when running my
>program, SAS tells me that I don't have SASIOODB.
>Is a driver called SASIOODB.dll should be installed with SAS/ACC-PC (folder
>libname myfile odbc dsn=mylabel;
>where mylabel is the alias I defined in Data Sources (ODBC)
>ERROR: Module SASIOODB not found in search paths.
>ERROR: Error in the LIBNAME statement.
>I'm on Win2000 with SAS V8e
>Any Idea anyone?
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Michael L. Davis
Bassett Consulting Services, Inc.
10 Pleasant Drive
North Haven CT 06473-3712