Excel 2010 import from MSquery Time Column

Posted on 2011-04-21
Last Modified: 2012-05-11
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!
Question by:mcrossland
    LVL 30

    Accepted Solution

    Seems like this is exactly that you are facing?

    Topic: data imported from access using microsoft query

    LVL 10

    Author Closing Comment

    Unix database "time" had to be modified.  Problem solved.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now