Date:         Wed, 26 Jun 1996 14:53:39 PDT
Reply-To:     TWB2%Rates%FAR@GO50.COMP.PGE.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         TWB2%Rates%FAR@GO50.COMP.PGE.COM
Subject:      Re: SAS ODBC to ACCESS, How do you do it?
Comments: To: bercikj@MUSC.EDU

John, Are you trolling for flames?  Do you read your mail?  Do you read
comp.soft-sys.sas?  Several people have sent you partial replies, and
your continued postings do not reflect any of this content.
 
What version of SAS are you running? 6.08? 6.10?  If you run PROC
SETINIT, are you licensed for PROC ACCESS?  In the Windoze Control
Panel, do you have an ODBC icon?  If you click it to list the drivers,
do you have an ODBC driver for MS Access or MS Access 2.0 (and which
version of Access do you want to read)?  If you start SAS and enter:
 proc sql;
   connect to odbc (prompt);
 
Do you get a list of drivers or an error message (I get the error
message because I do not HAVE ODBC, so I cannot take you any further)?
 
Good luck, but since you offered to call and accept advice on your
nickle, please call 919-677-8008 and talk with the people who get paid
to help you.
 
 
----------------------[Reply - Original Message]----------------------
 
Sent by:John Bercik <bercikj@MUSC.EDU>
 I am trying to read my Access tables directly into SAS using ODBC.
Does anyone
know how to do this in less than a couple of pages?  The SAS books have
me
totally confused?
 
I can save them as every other Excel / DBF type , but I need to be able
to work
in the native format reading the tables in Access directly.  Can you
help?
 
=====================================================================