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

Posted by mysqlizor on Stack Overflow See other posts from Stack Overflow or by mysqlizor
Published on 2010-03-08T08:06:37Z Indexed on 2010/03/12 8:07 UTC
Read the original article Hit count: 165

Filed under:
|
|
|

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?

© Stack Overflow or respective owner

Related posts about excel-vba

Related posts about excel