Hi Dan,
Sorry for causing additional work to getting the test setup, I will take
your advice should I need to post these type of details again
With regards to your solution, it works perfectly!!! Great thanks for
putting the time and effort in to help sort this problem. Much appreciated.
I
Dan Wareham wrote:
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't
get the thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't get the
thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question is the Users
tabl
Dan Wareham wrote:
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for
Excel to select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I
get the current date in the format DD
