To use PROC EXPORT or PROC IMPORT with EXCEL, you need ACCESS to PC FILES. You can run PROC SETINIT to see if you have that licensed. You also have to be running on Windows. You have other options if you are not on Windows - XLSX will work on other operating systems, or you can use a PC Files Server with EXCELCS. If you don't license ACCESS to PC FILES, you can use ODS EXCEL to export files, but that's not a solution for importing them. For import you may want to use a third party product, or just go into Excel and save to CSV.
Also, in the future I recommend searching on your error first. Doing so (in Google, no less) found this thread as its first hit for me:
https://communities.sas.com/t5/SAS-Procedures/ERROR-DBMS-type-EXCEL-not-valid-for-export/td-p/249383
... View more