[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: proc access for excel error
From:       Nelson Harrison <nelson () MNSI ! NET>
Date:       1999-10-29 21:01:50
[Download RAW message or body]

Don,

  Save it as 95 format only.  I've never tried saving it as both.

Nelson


On Fri, 29 Oct 1999 16:05:27 GMT, DonMayfield <DonMayfield@excite.com>
wrote:

>In article <3819c5ee.580842@snews.mnsi.net>,
>  nelson@mnsi.net (Nelson Harrison) wrote:
>> You get this error when trying to use PROC ACCESS with an Excel 2000
>> spreadsheet.  Either resave the spreadsheet to Excel 95 or you will
>> have to use PROC IMPORT which in my case for v6.12 an addon was needed
>> for that to even work.
>
>I saved it as both Excel version 5/95 and 2.1 and still got the
>same error.  I will look into proc import as I am using version 7
>of sas.
>Don
>>
>> Any other questions let me know since I just went through this.
>>
>> Nelson

[prev in list] [next in list] [prev in thread] [next in thread]