Date: Wed, 26 Jun 1996 14:53:39 PDT
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
Subject: Re: SAS ODBC to ACCESS, How do you do it?
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:
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.
know how to do this in less than a couple of pages? The SAS books have
I can save them as every other Excel / DBF type , but I need to be able
in the native format reading the tables in Access directly. Can you