What datetime formats are supported in Import?

This topic is locked

What datetime formats are supported in Import?	1/16/2011 2:59:41 AM
ASPRunnerPro General questions
B bob@symantry.com author I have an Excel spreadsheet with a date/time field that I am trying to load into mySQL. I can import all of the data but the time part of the field is lost. If I convert the date to a text string in Excel, the import fails in an ugly way. The error is as follows: Microsoft VBScript runtime error '800a0006' Overflow: 'cint' /include/locale.asp, line 644 I've tried the mySQL default of "YYYY-MM-DD HH:MM:SS" and this fails with the CInt error. I also tried "YYYYMMDDHHMMSS" and this also fails. Any pointers? Thanks /Bob


	Sergey Kornilov admin 1/17/2011
	Bob, I would suggest post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL along with Excel file in question. We'll see what we can do.