How to save Excel date time cell into MySQL using VBA?

Question

The mysql table has a DATETIME field. I want to INSERT a new row into this field using the cell data from the Excel worksheet. But I cannot use the datetime formatted cell value in a INSERT INTO query. How can I implement this?

Answer 1

You could create a custom format that represents the datetime in the correct way.