Date:         Thu, 6 May 2004 07:27:13 +0100
Reply-To:     Ari Toikka <toikkari@YAHOO.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ari Toikka <toikkari@YAHOO.CO.UK>
Subject:      Re: SAS and MS Access
In-Reply-To:  <vmimc.48969$ZJ5.1500087@news20.bellglobal.com>
Content-Type: text/plain; charset=iso-8859-1

Hi,

if you have ACCESS to PC Data files licensed,
you can use the import / export wizards (File / Import Data)
You can then save the generated program, which
might look for example like this:

Proc import out = sasuser.test
     datatable="h456test"
     dbms =ACCESS97 replace;
     DATABASE="T:\h345test.mdb";
run;
If you have columns in MS Access having a length over 1024 characters,
you have to add:

Memosize=xxxxxxx ;   /* xxxxx=the maximum length */

Ari Toikka
Statistics Finland






Peter Hruby <hrubyp@SYMPATICO.CA> wrote:Hi SAS-L,

I am wondering what choice do I have to access tables in MS Access datbase.
Can I use SAS/Access to ODBC or SAS/Access to PC Files or DDE or WB scripts?
I appreciate any experience and examples.

Thanks
Peter.


---------------------------------
  Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now