[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: ERROR: Connect: External table is not in the expected format.
From:       Arthur Tabachneck <art297 () NETSCAPE ! NET>
Date:       2010-02-28 23:53:02
Message-ID: 04fa4429-25a1-40d0-b77f-0fb12afcbd89 () 33g2000yqj ! googlegroups ! com
[Download RAW message or body]

Lee,

There are a number of SAS technical notes on this.  If you're not on
9.2 phase 2, you may have to intall that to solve the problem (other
than, of course, simply opening the file in Excel and saving it in an
earlier format).  I really don't know if that version of office/excel
has to be intalled as well.

The critical note I saw was: http://support.sas.com/kb/32/455.html

HTH,
Art
----------
On Feb 28, 1:29 pm, SAS User <sasuser2...@googlemail.com> wrote:
> Hi,
>
> I get the following error when I use a .xlsx file but if I use a .xls
> it works fine. Does the server need installed a new version of office?
>
> 9    proc import
> 10   datafile = 'test.xlsx'
> 11   out = test.test dbms=excel replace;
> 12   run;
>
> ERROR: Connect: External table is not in the expected format.
> ERROR: Error in the LIBNAME statement.
> Connection Failed.  See log for details.
> NOTE: The SAS System stopped processing this step because of errors.
> NOTE: PROCEDURE IMPORT used (Total process time):
>       real time           1.01 seconds
>       cpu time            0.23 seconds
>
> Thanks
> Lee
[prev in list] [next in list] [prev in thread] [next in thread]