I would add to Andrew's missive a couple of things. I utilize SAS with MS-Access in the following ways: 1) I Use ODBC to get data from MS-Access to SAS datasets 2) I Use DDE to transfer data to MS-Access from SAS datasets and further manipulate the Access tables. However, when I manipulate the tables I am using MS-Access Basic commands routed through SAS with "data _null_" and "put" statements. It is ^not^ the easiest way of working with MS-Access.

Randall Cates, SAS Consultant Arbor Consulting Resources rccates@mkg.com (alternate randycates@msn.com)

---------- From: Andrew James Llwellyn Cary[SMTP:ajlcary@IX.NETCOM.COM] Sent: Sunday, December 29, 1996 11:31 PM To: Multiple recipients of list SAS-L Subject: Re: Microsoft Access

Use ODBC to connect to an Access database from SAS. When the connection is done well, the individual tables in access look like SAS datasets. Do be aware that Access supports many more data types then SAS. The ODBC driver does it's best to convert everything to either character or numeric.

WH <huiw&r@localnet.com.au> wrote in article <01bbf579$be34cd40$106f19cb@localnet>... > Does anyone know whether SAS can manipulate a Microsoft Access file and if > so how is it done. > > Thanks in advance >