| Date: | Wed, 21 Aug 2002 17:52:50 -0400 |
| Reply-To: | Robert Abelson <rabelson@KAI-RESEARCH.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Robert Abelson <rabelson@KAI-RESEARCH.COM> |
| Subject: | Re: Access97 |
| Content-Type: | text/plain |
|---|
Reddi,
If you have SAS Access to ODBC, and ODBC is set up, you can use something
like this:
proc sql noprint ;
connect to odbc
(required="Driver={Microsoft Access Driver (*.mdb)};
DBQ=&inpath;
SYSTEMDB=C:\WorkGroup\System.mdw;
UID=me;PWD=mypasswd;");
HTH.
Bob Abelson
KAI
6001 Montrose Rd.
Suite 920
Rockville, MD 20852
T: 301-770-2730
F: 301-770-4183
rabelson@kai-research.com
> -----Original Message-----
> From: Reddi [SMTP:reddy_sas2000@YAHOO.COM]
> Sent: Wednesday, August 21, 2002 5:22 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Access97
>
> Hi,
>
>
>
> I need to access the MS-Access97 database . I want to access through the
> Proc Sql pass through facility. Can any body let me know how to access.
>
> Thank You
>
>
> Reddy
|