If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Microsoft Query Data not coming over

Thread starter Srushbri1
Start date Oct 5, 2017
Tags

data excel query query editor wizard

Srushbri1

New Member

Oct 5, 2017

Hi, I used the Microsoft Query to access data from an access DB that I maintain. when I import it, I view the data in the Wizard tool and it has the correct data but once I close out of it, the data that is imported into the Excel (in table form) is not right. Particularly any columns that have time/hours. I try to go back into the wizard tool to view the data and it looks right again but it's not coming over to the excel table. In excel every entry shows up as 12:00:00. I did notice that in the Wizard instead of just a time stamp it shows 12/30/1899 HH:MM:SS.

Any insight?

thanks,
Sofia