|Date: ||Sat, 13 Dec 1997 17:33:48 +0100|
|Reply-To: ||Aramis <aramis@GLOBALXS.NL>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Aramis <aramis@GLOBALXS.NL>|
|Organization: ||GlobalXS BV|
|Subject: ||Re: MS ACCESS to SAS DATASET|
|Content-Type: ||text/plain; charset=us-ascii|
More specifically what you want to do is the following:
* If you haven't already installed the ODBC driver for MS Access, do so
* Use the SQL-passthrough to get the meta info on the MS Access table(s)
Table_Qualifiers, Table_Name etc.
* Use meta info in data step (may want to use a macro)
> I did the trick by using the ODBC engine. But bear in mind that the
> afterwards in SAS itself.
> Shan Putnam <email@example.com> wrote in article
> > Can anyone shed some light on getting SAS to read MS access tables?
> > Any suggestions would be very, very helpful.
> > Shan