Date:         Mon, 28 May 2001 16:51:01 -0400
Reply-To:     laura_grady@ncsu.edu
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Laura B Grady <lbgrady@UNITY.NCSU.EDU>
Organization: NC State University
Subject:      Re: new Excel => import problems
Content-Type: text/plain; charset=us-ascii

Try...:

SN-003583
v8.1 Import MSExcel 97/2000 Text Columns Imported with Length of 255


Using SAS 8.1/ACCESS Software for PC File Formats to read in an Excel
97/2000 text field, with PROC IMPORT or the Import Wizard, text columns
are imported with a length of 255.

This behavior is fixed in the following file:

        PCFF_P81.ZIP

>From the SAS Home Page -> Service & Support -> Technical Support ->FTP
Site -> SAS System on Personal Computers -> pcff_p81.zip


Product:  SAS/ACCESS (General)
Component: ACCESS procedure or window
Priority:  MEDIUM
Status: Usage Issue
Date: Sun, 29 Oct 2000

"Ephraim I. Schechter" wrote:
>
> Our network techs just installed an Excel upgrade, to Excel97 SR-2.  Proc
> Import now brings Excel files into SAS with all character fields set to
> $255 instead of to the length of the Excel field. This happens whether I
> specify dbms=excel97, dbms=excel2000, or just leave dbms= out of the proc
> import statement. I'm using SAS 8.01 (TS level 01M0) under WinNT.
> Microsoft's Data Access Components got overwritten with an older version by
> the Excel upgrade, but reinstalling MDAC v2.5 doesn't help.
>
> Any ideas on how to make the import read lengths properly? I've got a
> suite of programs with a lot of import steps, and am trying to avoid
> adding code that controls variable length to each one.
>
> Thanks --
> Ephraim
>
> --------------------------------------------------
> Ephraim Schechter
> Associate Director, University Planning & Analysis
> North Carolina State University
> eischech@unity.ncsu.edu