Hoping for a solution to this problem I have of trying to import a time into excel. I am connecting to a company server to import data using Microsoft Query. I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good when I view it on the server. This is the SQL I use to import the TIME only to MS Excel. SELECT warehouse_transactions.warehouse_trans_time, FROM warehouse_transactions warehouse_transactions WHERE (warehouse_transactions.whse_code='33') I have seen a CONVERT function but not sure how to implement it in this SQL string. If there is some way to have the TIME field import to Excel accurately I would be glad to see it. Thanks

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.

Converting time to text when importing from MS Query

Thread starter tropix
Start date Jul 15, 2015
Tags

convert time import time ms query sql

tropix

New Member

Jul 15, 2015

Hoping for a solution to this problem I have of trying to import a time into excel.
I am connecting to a company server to import data using Microsoft Query.
I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good when I view it on the server.
This is the SQL I use to import the TIME only to MS Excel.

Code:

SELECT warehouse_transactions.warehouse_trans_time, 
FROM warehouse_transactions warehouse_transactions
WHERE (warehouse_transactions.whse_code='33')

I have seen a CONVERT function but not sure how to implement it in this SQL string.
If there is some way to have the TIME field import to Excel accurately I would be glad to see it.

Thanks