Date:         Thu, 22 Jan 1998 23:07:33 -0800
Reply-To:     Andrew James Llwellyn Cary <ajlcary@CARYCONSULTING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Andrew James Llwellyn Cary <ajlcary@CARYCONSULTING.COM>
Subject:      Re: Best Way to Port MS-ACCESS97 File to SAS?

On Wed, 21 Jan 1998 17:37:02 -0600, Paul Pope <p-pope@tamu.edu> wrote:
 
>What's the least painful way (in terms of keeping the original structure
>and data intact) of porting a MS-ACCESS97 file to SAS 6.12 (for the PC)?
 
If you know how to use ODBC you can easily export an Access table to a SAS
dataset.
 
(1) Establish a SAS ODBC connection (The SAS ODBC server is part of the base
product) from
within MS-ACCESS.
 
(2) Use MS-Access to EXPORT the file to the ODBC connection. This puts the
file in the WORK
libref of the SAS ODBC Server session.
 
(3) Use Windows Explorer (or DOS) to copy the SAS file to a different
directory of your choice.
 
DO BE AWARE that  MS-Access supports data types not supported by SAS!
 
See my WUSS papers on ODBC( 95 or 96)  for the conversion tables..
 
-----
Andrew JL Cary,
Chief Curmudgeon
Cary Consulting Services, Newark CA 94560
http://www.caryconsulting.com