When you use the ACCESSCS engine to export date variables to Access databases, the following datetime-field overflow errors can occur:

ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver]Datetime field overflow
       (null)
WARNING: File deletion failed for _IMEX_.cacs6.DATA.
ERROR: Export unsuccessful.  See SAS Log for details.

This problem occurs when you export date values earlier than the year 1753. The ODBC driver that is used by the ACCESSCS engine cannot use date values earlier than 1753.

Operating System and Release Information

data a;
input data ddmmyy10.;
format data ddmmyy10.;
cards;
01/05/1752
01/04/1752
01/03/1752
01/02/1752
01/01/1752

;
run;

proc print data=a;
run; quit;

proc export dbms=accesscs
data= a
OUTTABLE= "cacs6" replace;
DATABASE="C:\sastest\a.Mdb";
server="itsvista0819.na.sas.com";
port=8621;
run;