Date:         Tue, 16 Nov 1999 11:32:47 -0500
Reply-To:     "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke Clinical Research Institute
Subject:      Re: Q: comparison DDE vs. ODBC (practice test)
Content-Type: text/plain; charset=us-ascii

I'm biased, but I would go with ODBC.  I've always found DDE clumsy in dealing
with Excel (and haven't attempted it with Access).  ODBC is also closer to OLE,
which seems to be the way that Microsoft is going with inter-product
communications (See SUGI 24 paper #136 at
http://www.sas.com/service/techsup/news/v8sugipapers.html ).

Actually, with a dataset that small, I'd just use DBMS/Copy V7 and convert it
directly to SAS.

Doc

"Christian F.G. Schendera" wrote:

> experience from the field wanted! if you'd have to access an ACCESS db with,
> say +100 vars x +1000 obs (SAS 6.12, WIN98), would you pick DDE or ODBC,
> and:
> why?
> thanks in advance, Chris

--
Lawrence H. ('Doc') Muhlbaier           muhlb001@mc.duke.edu
Assistant Research Professor
Duke University Medical Center          919-668-8774 (office)
DUMC 3865                               919-383-0595 (home)
Durham, NC 27710-7510                   919-668-7057 (FAX)