Need help with importing Date() using parameterized query...
Posted on 2009-07-15
I'm using a parameterized query to import a record from my MySQL Database into Access. I want the date to be formatted as, "mm/dd/yy", but I'm not sure of the Constant to use in my .CreateParameter statement. I tried this:
.Parameters.Append .CreateParameter(, adDBDate, adParamInput, , Format(Date, "mm/dd/yy"))
but that doesn't work since the format for adDBDate is "yyyy/mm/dd".
How can i do it? It is important that I store the date in the format I specified.