Out of curiosity, have you tried both changing the DBMS=EXCEL to DBMS=XLS,
as well as commenting out the last three lines (i.e., commenting out or
On Mon, 17 Aug 2009 14:08:45 -0700, Nancy <nancy0318@GMAIL.COM> wrote:
>PROC IMPORT OUT= WORK.Spec2
> DATAFILE= "J:\Hsee\Spec\SpecB.xls"
> DBMS=EXCEL REPLACE;
>I tried to import the excel data, however, I always get the following
>ERROR 180-322: Statement is not valid or it is used out of proper
>I tried to put this statment for several places, it did not work.
>What is wrong ?
>Thank you so much!