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:

Correction:

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.