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;
... View more
