Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Front-Line
Starting Member
4 Posts |
 Posted - 2009-11-04 : 15:43:57
|
| Hey there,I'm importing data from a mdb file via MS query into excel. I got 2 columns in this file.Hour Minute8 08 309 09 3010 010 3011 011 30What I want to do is combine these 2 columns so I get 1 column that displays time when I will import back to excel. So I did this in another column in MS query: Hour&':'&MinuteThat is returning it as the following format 8:0, 8:30, 9:0, 9:30 etc..However excel isn't recognizing that this is time, is there anyway to apply a format to it so that excel would recognize it ? |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2009-11-05 : 06:00:38
|
| how are you exporting it to excel?and what are the results from excel file?RobMCTS certified |
 |
|
|
|
|
|
MS QUERY EASY FORMATING QUESTION