[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 652
  • Last Modified:

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,
0
mcrossland
Asked:
mcrossland
1 Solution
 
SiddharthRoutCommented:
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

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now