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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Importing Excel Table With Times As Column Heading, Access 2016    
 
   
davideyles
post Aug 16 2017, 03:05 PM
Post#1



Posts: 209
Joined: 13-April 03
From: Cornwall, UK


Hi
I am trying to import a table (attached) into Access, but it wont accept the time in the column heading as a time and puts in a number rather than the time. Any ideas??

David
Attached File(s)
Attached File  HH_Data_Export.zip ( 331.05K )Number of downloads: 14
 
Go to the top of the page
 
doctor9
post Aug 16 2017, 04:12 PM
Post#2


Remembered
Posts: 18,324
Joined: 29-March 05
From: Wisconsin


David,

Your Excel data looks like it needs to be Normalized, so I threw together a quick-and-dirty database that will store one record for each unique value, with the date/time for that value stored as well.

Hope this helps,

Dennis
Attached File(s)
Attached File  ImportDemo.zip ( 41.38K )Number of downloads: 15
 
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th December 2018 - 07:31 AM