UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> get external data from MS Excel problem    
 
   
xmxpcom
post Oct 11 2005, 08:36 AM
Post #1

New Member
Posts: 12
I have an Excel spreadsheet. In a cell it contains 13:37, 13:58, etc as time. When I imported it into Access table using Get External data wizard, all the values in this cell has been converted into a numerical values like
0.56736111111,0.58194444444, etc. Please help. how can I keep format as 13:37 instead of 0.56736111111 in Access?
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 1)
NateO
post Oct 11 2005, 10:26 AM
Post #2

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
Actully the number should be preserved, that's a serial time. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Change the Field's data type in your Table to a 'Date/Time' and set the Format to 'Short Time'.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 09:21 PM