Excel 2010 import from MSquery Time Column

I have a strange issue occurring only with Excel 2010.
I have narrowed the problem down to strictly this version of excel and it doesn't happen on systems that have Excel 2007 or earlier.

I run a query against a database that includes DATE and TIME columns and return the results to MSquery.  
Example:  Date returns 2011-04-11 and Time retuns 05:24:00
When I return data to Excel 2011, I get the following under all the time columns: 0:00:00
It's not pulling the times from MSQuery.
My only current solution is to go back to office 2007 which is not what I'm looking for.  
Help would be greatly appreciated!
Thanks,
LVL 10
mcrosslandAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
Seems like this is exactly that you are facing?

Topic: data imported from access using microsoft query
Link: http://social.technet.microsoft.com/Forums/en-US/excel/thread/71d1e350-8dd3-4f42-9a1a-48d88ff2f573

Sid
0
 
mcrosslandAuthor Commented:
Unix database "time" had to be modified.  Problem solved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.