Converting time to text when importing from MS Query

tropix

New Member
Joined
Mar 6, 2014
Messages
9
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
 

Forum statistics

Threads
1,085,577
Messages
5,384,546
Members
401,907
Latest member
Djmason2001

Some videos you may like

This Week's Hot Topics

Top