mcrossland
asked on
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,
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER