Updating date from Excel VB

[Dr Zenith]

Guys,

I have an Access 2003 database with one of the column taking being Date/time data type. I am trying to edit the data in the database by taking in values from Excel through VBA (Am using ADODB connection). After editing it through the VB macro, all the modified values in database are changed to 1/0/1900 (which I understand to be the default date in Excel / Access).

I also tried editing the Format of the Date data-type to short date, but still the same thing.

Expecting some help on this!!

 

[Dr Zenith]

And just an FYI - the technical term for it is an Octothorpe (#). (Just thought I would share that, in case you ever hear the term)

Indeed I've never heard the term before. My vocabulary has increased today!

Great! What's an octothorpe?

Now, is this Memento revisited?