Unable to import xlsx file using PROC IMPORT.

[441418]

Unable to import xlsx file using PROC IMPORT. I tried to use DBMS = xlsx on SAS 9.4 M7.

[Tom]

Don't attach files.  If you want to share text click on the Insert Code icon and paste the text into the pop-up window.  It you want to attach an image you can paste it into the normal editor box.  Or click on the Insert Photos icon and either drag it there or browse to the file and select it.

[CodeName · Accepted solution]

Use SAS/ACCESS Interface to OLEDB
In SAS/ACCESS interface to OLEDB, you can submit the following code to create or read an .xlsx file with Microsoft office 2007 OLEDB

libname LibTest oledb init_string="Provider=Microsoft.ACE.OLEDB.12.0;
data source='C:\Excelfiles\Air.xlsx';
extended Properties=Excel 12.0";

data Test;
set LibTest.'Air3'n;
run;

[Kurt_Bremser]

---

@441418 wrote:

Unable to import xlsx file using PROC IMPORT. I tried to use DBMS = xlsx on SAS 9.4 M7.

---

Open the file in question with Excel or other office software to see if it is valid.