Thanks For the Quick Reply

Error Message is :

Arguments are of Wrong Type or out of Acceptable range or Are Conflict
with One Another.

---------------------
Here is the Code:-

AdoQry.Parameters.ParamByName('Prm0').DataType:= ftTimeStamp;
AdoQry.Parameters.ParamByName('Prm0').Value :=
VarToDateTime(RSt.Fields['S_DATE'].Value);
---------------------
RSt.Fields['S_DATE'] is a DateTime Field in MSAccess

If I use 'ftDateTime' it will insert Null Values.

TIA

Dilish