proc export using accesscs: datetime field overflow error

[gzr2mz39]

Hi,

Does anyone know how I can fix this error when running the proc export seen below?

ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver]Datetime field overflow

WARNING: File deletion failed for _IMEX_.CR_ACT.DATA.

NOTE: PROCEDURE EXPORT used (Total process time):

      real time           16.22 seconds

      cpu time            0.11 seconds   

ERROR: Export unsuccessful.  See SAS Log for details.

proc export data=claims

outtable="CR_ACT"

dbms = ACCESSCS

label

replace ;

database="C:\temp\EnvClear.mdb";

server="&DEVICEID";

port=&portid;

run;

[gzr2mz39 · Accepted solution]

I found that _BIC_CST was equal to 01APR1715.

I fixed that record and proc export ran successfully.