In reply to Neil Gundel.

Neil,

My favorite way to import Excel is to by using PROC IMPORT and DBMS=XLSX. Also, PROC EXPORT and DBMS=XLSX supports the updating of individual sheets, without having to recreate the entire file.

MS Access is trickier. You can use PROC EXPORT to MS Access, but only (I think) if the bitness matches or by using PC Files Server (also look at LIBNAME PCFILES). Another method - if you're on Windows SAS -- try an ODBC connection to your MS Access database.