Importing .xlsb file into SAS EG 6.1

[ankit_agrawal]

Hi,

I am trying to import .xlsb file into SAS EG 6.1 using proc import command.

The code works fine for xlsx file but throws an error for .xlsb file.

proc import datafile="test/import1.xlsb"

out=output_test

dbms=xlsx replace;

sheet="test1";

getnames=yes;

datarow=2;

run;

I have tried using dbms=excel also but it is not working

Can you help me know the workaround for this?

[Reeza]

Have you tried DMBS=ExcelCS or DBMS-PCFILES/PCFS

[SASKiwi]

What is the error?