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) i.e. Table_Qualifiers, Table_Name etc. * Use meta info in data step (may want to use a macro)

Steve Tjin SAS Consultant

SCB wrote:

> I did the trick by using the ODBC engine. But bear in mind that the > [edited]

> afterwards in SAS itself. > > Shan Putnam <sputnam@blue.weeg.uiowa.edu> wrote in article > <66950c$knu$1@flood.weeg.uiowa.edu>... > > > > Can anyone shed some light on getting SAS to read MS access tables? > [edited]

> > > > Any suggestions would be very, very helpful. > > > > Shan > > > > > >