Date:         Fri, 12 Jan 2001 12:16:27 -0500
Reply-To:     Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Subject:      Re: PROC ACCESS for Excel 2000 Files
Comments: To: Terry Fudin <t.fudin@GENAISSANCE.COM>
Content-Type: text/plain; charset="iso-8859-1"

Terry,

Worked well in 8.0.  Doesn't work so well in 8.1 - something about MDAC
services not performing as advertised.  Promised to be fixed in 8.2.  "Never
trust the odd-numbered releases."  In any event, here's a short example:

proc import
  datafile = "Your.Excel.File.xls"
  out = YourDataSetName
  dbms="EXCEL2000";
  sheet = "ASheetName";
  getnames = yes;
  run;

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


+ -----Original Message-----
+ From: Terry Fudin [mailto:t.fudin@GENAISSANCE.COM]
+ Sent: Friday, January 12, 2001 11:50 AM
+ To: SAS-L@LISTSERV.UGA.EDU
+ Subject: PROC ACCESS for Excel 2000 Files
+
+
+ In SAS Version 6.12 one could NOT use PROC ACCESS to read
+ Excel Windows 97
+ and Windows 2000 files. Is this still true in Versopn 8.1? I
+ don't want to
+ use the Import/Export Facility but I want to use my SAS
+ program to read and
+ convert the EXCEL 2000 files to a SAS dataset. Does anybody
+ know what the
+ best way to accomplish this in a SAS program is, and can you
+ give me an
+ example?
+
+ Thank you!
+
+ Terry Fudin
+ Cyberlytical, LLC
+ SAS Consultant to Genaissance, Inc.
+