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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,099,086
Messages
5,466,544
Members
406,486
Latest member
varmehta

This Week's Hot Topics

Top