ERROR: DBMS type XLSX not valid for import.

[nab102]

Hello, 

I'm having trouble importing xlsx file and I keep getting this error "ERROR: DBMS type XLSX not valid for import." . Can someone help?

proc import datafile="path\Data.xlsx"
dbms=xlsx out=dm replace;
run;

[Tom]

Install a new version of SAS?

https://blogs.sas.com/content/iml/2013/08/02/how-old-is-your-version-of-sas-release-dates-for-sas-so...

To check the version of SAS you are running check the macro variable SYSVLONG.  To check what is installed use PROC PRODUCT_STATUS.

I know XLSX engine works with this 4.5 year old version of SAS (which does have SAS/Access to PC Files installed).

79   %put &=sysvlong;
SYSVLONG=9.04.01M5P091317
80
81
82   proc product_status;
83   run;

For Base SAS Software ...
   Custom version information: 9.4_M5
   Image version information: 9.04.01M5P090617
...
For SAS/ACCESS Interface to PC Files ...
   Custom version information: 9.4_M5
...

[nab102]

This is my version
149 %put &=sysvlong;
SYSVLONG=9.04.01M7P080520


For Base SAS Software ...
Custom version information: 9.4_M7
Image version information: 9.04.01M7P080520
For SAS/STAT ...
Custom version information: 15.2
For SAS/GRAPH ...
Custom version information: 9.4_M7
For SAS/IML ...
Custom version information: 15.2
For High Performance Suite ...
Custom version information: 2.2_M8
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M7

[Kurt_Bremser · Accepted solution]

So you do not have SAS/ACCESS to PC Files installed. Run PROC SETINIT to check if it is also not licensed (most probably).

Save your spreadsheet as a CSV file, and read it with a data step.

[nab102]

I already converted the files from xlsx to csv but I had multiple files in the xlsx files in one excel worksheet so I thought there was going to be an easier way to do that. Thanks

[nab102]

Thank you