Importing Data from Access into Excel using microsoft query

[JessicaW]

I am attempting to use Microsoft Query to pull data from Access into Excel. It works great with 95% of my problems but when I use a specific table it will not allow me to pull the times. When I run the query all of the data is returned but the time columns are always 00:00 no matter the format I select.

The strange thing is I can do it in Excel 2007 but not on 2010. Is there a feature in 2010 that will not allow me to pull time data?

Thanks for the help.

1.PNG

[JessicaW]

And here is a shot of the results from Excel 2007 Attachment 204038