Trouble exporting time from Excel to MS Access

Hello !

I am currently trying to export data from an Excel worksheet to an Access table, and the only problem I can't solve is the following one :
While exporting data (Date, Numbers, text) is working well, it doesn't seem to work for the time. In my cell I have the function NOW, and the cell is formated to display hh:mm (24h format, btw). When I send it to Access, if the type is Date/Time (full time), the cell is blank. If the format is date it does display the date, though, and the same if it's text. When displaying it as a number, it shows an INTEGER.

Am I doing something wrong with the format type (either Excel or Access) or is it necessarily from my VBA code ?

My VBA macro in Excel contains the following :

Please Login or Register  to view this content.

Thank you all,

François

Edit : Put code into first message

You should use a Date/Time field in Access and format it to display time.

If you did use a Number field you would have to change from Integer to Decimal/Double, with Integer you lose the time part and are left with only the date part.

In Access you enclose date/time values in # not ', try changing the INSERT statement to reflect that.

What exactly did you try and how did it stop the code working?

What exactly do you have in the cells?

Can you upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.