LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 22 Oct 2002 17:07:15 -0400
Reply-To:   dkonkler@WLGORE.COM
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   dkonkler@WLGORE.COM
Subject:   Re: Libraries, ODBC, and Access database

Dale,

This won't get you exactly a clean libname reference, but to pull all the ACCESS tablenames I pull the contents of the table msysobjects, then select all the names where type=1 and the name does not start with 'msys'. That gets you all the real tables (at least in the db that I work with). Then I use a macro to pull over each table into SAS.

Dan


Back to: Top of message | Previous page | Main SAS-L page