So it definately is an Excel file then.  Ok, well to be honest, my advice does not really change much anyhows.  Save the file into a text based delimited file format - i.e. a proper data transfer file format - then write a datastep import program.  Excel is not structured and proc import is a guessing procedure, these will cause you headaches.  Importing a simple text file is very simple and you have full control over what columns are imported, what type they are etc.   ... View more

As I mentioned and as @ballardw has demonstrated with and example, a DATETIME variable is much easier to work with than a character string. ... View more

If you have a macro using the PC File Server, why can't you write your own code to do the same thing? The PC File Server doesn't have to be installed on the same Windows computer as your Access database. It could also be installed on your desktop. PROC IMPORT DATATABLE='Customers' DBMS=ACCESSCS OUT=SASCUSTOMERS REPLACE; DATABASE='mydrive:\yourAccessdirectory\AnnualFiles.accdb'; SERVER="yourPCFServer.com"; PORT=9621; DBDSOPTS='READBUFF=30'; RUN; ... View more