 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008get date/time into the same column?
Hello, I have records like 2008-05-16 11:58:43 2 fred@fred.com 1 5 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL How do I get these into Access 2003 keeping the date/time, i.e. the 2008-05-16 11:58:43 in the same column? I would expect to use a space to separate the fields but that cannot work if I want to keep the date/time in the same column? Help! Cheers Geoff >Hello, > [quoted text clipped - 10 lines] >I would expect to use a space to separate the fields but that cannot >work if I want to keep the date/time in the same column? Is this a text file or a table? If it's a Text file, use File... Get External Data... Import, and use Advanced to set up an import specification.  SignatureJohn W. Vinson [MVP] >>Hello, >> [quoted text clipped - 13 lines] >Is this a text file or a table? If it's a Text file, use File... Get External >Data... Import, and use Advanced to set up an import specification. John, It is a text file - I will try what you say. Thanks Geoff >>Hello, >> [quoted text clipped - 13 lines] >Is this a text file or a table? If it's a Text file, use File... Get External >Data... Import, and use Advanced to set up an import specification. John, cannot see how to do this! any pointers? Thanks Geoff >>>Hello, >>> [quoted text clipped - 17 lines] > >cannot see how to do this! any pointers? Open your database; use File... Get External Data... Import. From the dropdown list at the bottom of the window (labeled "Files of type") choose Text Files. This may be tricky and may require some pre-processing of the text file if you have variable length fields though! I can't immediately see how to use blanks as the delimiter without it importing the date and time as separate fields. If you do so, you can reconstruct a date/time value by simply adding the date to the time, numerically: an update query updating a date/time field to [datefield] + [timefield] will combine them correctly. SignatureJohn W. Vinson [MVP] >Open your database; use File... Get External Data... Import. From the dropdown >list at the bottom of the window (labeled "Files of type") choose Text Files. [quoted text clipped - 8 lines] > >will combine them correctly. John, thanks for the above - all is well agin! Cheers Geoff |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.