Hi,
As you can read in this post, I am importing data form Excel into MSAccess through VBA code.
The strange thing is that in MS db the date field is default : 16-4-2005 10:15:25
(Time is not visible in the forms)
In the xls sheet the column with dates has the propertie dd-mm-yyyy
So I changed in MS db the data field to dd-mm-yyyy
But after importing all dates are :30-12-1899
What's wrong ??