loosing the hhmmss when exporting datetime to Microsoft Access through macro (vba and SQL)

Hi All,

I'm using excel to export data from a CSV file to Microsoft Access.

One of the fileds is datetime (3/01/2019 12:02:00 AM). I can import the data into Access manually and the hhmmss remains however when I run it through the macro it is dropping off the hhmmss.

I have attached a sample CSV file, the import spreadsheet and a test Access database (sorry can't attach the Access file).

The data for 02/01/2019 and 03/01/2019 have been manually imported into Access and the data for 04/01/2019 has been imported through Excel.

the project called DataLoad does the loading work and ADOFuncs does the db connection work.


Any help is appreciated as it is driving me crazy.

Cheers

Dean


This is what is imported into Access (03/01/2019 manually imported and 04/01/2019 imported from Spreadsheet)
AccessPic.JPG