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: 204
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: 11
 
Go to the top of the page
 
doctor9
post Aug 16 2017, 04:12 PM
Post#2


UtterAccess Editor
Posts: 17,916
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: 9
 

--------------------
(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 02:55 PM