Date:         Mon, 31 Jul 2000 15:18:47 -0400
Reply-To:     Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Subject:      More on V8.1 SAS/ACCESS for PC File Format problems
Content-Type: text/plain; charset="iso-8859-1"

Dear SAS-L,

   Latest tidbit from tech support. - Jack

This information may be helpful to you:

We have discovered that the reason we are not reading in all the
variables is because the Microsoft import facility
(OLE DB ) we are using with 8.1, is not returning the
proper number of columns. This is an Excel bug.

In V8.0 of SAS/ACCESS to PC File Formats we used the Microsoft DAO
facility which is why this program worked fine in V8.
We switched from DAO in V8 to OLE/DB in V8.1 because of major problems
with DAO  (namely, it was not thread safe).


--
Jack N Shoemaker / JShoemaker@Accordant.net
Visit our patient communities at http://www.accordant.com or our corporate
site http://www.accordant.net