proc export using accesscs: datetime field overflow error

gzr2mz39 — Wed, 29 Apr 2015 23:45:49 GMT

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;

Re: proc export using accesscs: datetime field overflow error

gzr2mz39 — Thu, 30 Apr 2015 00:02:36 GMT

I found that _BIC_CST was equal to 01APR1715.

I fixed that record and proc export ran successfully.