Hi,

I am trying to get a time field in mysql table into a excel sheet using Microsoft query.

It displays the time as in the database but when I bring to excel it gives me a date.

ex time stored is 7:10:00 but when I get it into excel it gives a date in 2007.

Any help will be much appreciated.

thanks
Pathy