Date: Tue, 11 Jan 2011 20:13:37 -0500
Reply-To: Lorne Klassen <lk1@ROGERS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Lorne Klassen <lk1@ROGERS.COM>
Subject: Re: Proc Export difference between dbms=xls and dbms=excel
On Tue, 11 Jan 2011 18:32:55 -0500, Lorne Klassen <lk1@ROGERS.COM> wrote:
DBMS=EXCEL2003 is only an alias for DBMS=EXCEL so you can use DBMS=EXCEL.
But make sure your Excel file format remains 97-2003. Excel 2007 files are
not compatible with DBMS=XLS.
>For the last one I don't recommend DBMS=EXCEL because if it's the first
>time you are creating the workbook then it might create it in Excel 2007
>format. Then if you later try to add a sheet with DBMS=XLS, it will fail
>because DBMS=XLS is not compatible with Excel 2007.